Creating Linked Server in SQL
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.
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.