Month: February 2011

Creating a link between two SQL servers

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 of product, by default SQL Server @datasrc is the server you link to Then, you need to set the username […]