–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;
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
End
No comments:
Post a Comment