Friday, October 4, 2013

How to add the Linked Server (SQL Server) ?

–Linked Server  Query U add as under add the Server
if Not exists(select srvname from sysservers where srvname =’linkedsql’ )
Begin

exec sp_addlinkedserver @server=’linkedsql’,
@srvproduct= ”, @provider=’SQLOLEDB’,
@datasrc=’test’, @location=”, @provstr =’DRIVER={SQL Server};SERVER=test;UID=sa;

PWD=12345′ select * from [linkedsql].[test].[dbo].tbl_test
End

No comments:

Post a Comment