Ray's Asp.net Blog
Answers and code snippets from ASP.NET projects (Webforms/MVC/Classic ASP)
Pages
Event registration app with QR/Paypal
Home
Monday, July 23, 2012
How to copy a table from remote server to another server?
exec sp_addlinkedserver '255.255.255.255,1433';
exec sp_addlinkedsrvlogin '255.255.255.255,1433'
, 'FALSE', NULL, 'username', 'password';
select * into [newtablename] from [255.255.255.255,1433].[databaseName].[dbo].[tableName]
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment