SharpDeveloper
When using SQL Server Management Studio you might want to copy data from one DB to another (using just a SELECT and INSERT statement)
It’s so easy you won’t believe it
sp_addlinkedserver @server='192.168.123.456', @provider='SQLNCLI', @srvproduct='',@provstr='User Id=sa; Password=are-you-crazy-to-use-sa' insert into [192.168.123.456].MYDB.dbo.tblRecords select * from MYDB.dbo.tblRecords
and when you are done
sp_dropserver [192.168.123.456]
References:
sp_addlinkedserver on MSDN
Related Reading:
Other Interesting Posts
If you enjoyed this article, please consider sharing it!
error
Msg 208, Level 16, State 1, Line 4
Invalid object name ‘BuiltUP.dbo.tblRecords’.
abhijit thats just an example using example tables, you have to use the real table name you want!
sp_addlinkedserver @server=’192.168.2.134′, @provider=’SQLNCLI’,
@srvproduct=”,@provstr=’User Id=sa; Password=saptech@123′
insert into [192.168.2.134].BuiltUP.dbo.tblRecords
select * from BuiltUP.dbo.tblRecords
Please tell me thats not your real sa password
hahahaha