Advertisement
Guest User

Untitled

a guest
Mar 20th, 2019
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. EXEC sp_addlinkedserver @server='ServerName1', @srvproduct='', @provider='SQLNCLI', @datasrc='10.10.10.10'
  2. EXEC sp_addlinkedsrvlogin 'ServerName1', 'false', NULL, 'username', 'password'
  3.  
  4.  
  5. insert into [ServerName1].DatabaseName.dbo.TableName(column1,column2)
  6. select Column1, null from LocalTableName
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement