Monday, November 9, 2009

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