SQL Server

Creating a link between two SQL servers

, , No Comment

To create a link between two SQL Servers you need to use the sp_addlinkedserver and sp_addlinkedsrvlogin stored procedures. First, sp_addlinkedserver @server=’DBLINK01′,@srvproduct=”,@provider=’SQLOLEDB’,@datasrc=’SQL-HOU-01′; Where, @server is the name of the link @srvproduct is the type of product,…

Read Post →

Creating a link between two SQL servers

, , No Comment

To create a link between two SQL Servers you need to use the sp_addlinkedserver and sp_addlinkedsrvlogin stored procedures. First, [code] sp_addlinkedserver @server=’DBLINK01′,@srvproduct=”,@provider=’SQLOLEDB’,@datasrc=’SQL-HOU-01′; [/code] Where, @server is the name of the link @srvproduct is the type…

Read Post →