Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- EXEC sp_addlinkedserver @server='ServerName1', @srvproduct='', @provider='SQLNCLI', @datasrc='10.10.10.10'
- EXEC sp_addlinkedsrvlogin 'ServerName1', 'false', NULL, 'username', 'password'
- insert into [ServerName1].DatabaseName.dbo.TableName(column1,column2)
- select Column1, null from LocalTableName
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement