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
select * from [linkedsql].[test].[dbo].tbl_test
End
No comments:
Post a Comment