Creating Linked Server: [sql] EXEC sp_addlinkedserver @server=N’IIC82′, @srvproduct=N”, @provider=N’SQLNCLI’, @datasrc=N’IIC82\SQL2008R2′; [/sql] Here you need to replace with your server name.
I am Sibeesh Venu, an engineer by profession and writer by passion. Microsoft MVP, Author, Speaker, Content Creator, Youtuber, Programmer.