January 28, 2013 at 1:38 pm
I would like to script a table from my linked server so I can create it on my local DB. There is no option for this and wondered if anyone might have a suggestion?
Thanks
January 28, 2013 at 1:47 pm
you can get a pretty good copy of the table , which would not have the any foreign key constraints, by doing something with the INTO statement:
SELECT *
INTO MyNewTable
FROM MyLinkedServer.DatabaseName.dbo.TargetTable
WHERE 1 = 0
--no data transferred, but the table gets built.
another alternative, assuming it's a SQL server as the Linked Server is to simply connect with SSMS object explorer; then you can just drill down into the server/database/Tables, right click and script, instead of trying to do it via the linked server itself.
Lowell
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply