Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- EXECUTE sp_addlinkedserver @server = N'serverSQL2014', @srvproduct=N'sql_server', @provider=N'SQLNCLI10'
- EXECUTE sp_addlinkedsrvlogin @rmtsrvname='serverSQL2014', @useself='false',@rmtuser='sa', @rmtpassword='sa_password'
- EXECUTE sp_addlinkedserver
- @server = N'serverSQL2014',
- @srvproduct=N'sql_server', @provider=N'SQLNCLI10',
- @datasrc = N'serverSQL2014'
Add Comment
Please, Sign In to add comment
