Re: [SQLQueriesNoCode] How To Copy Tables Across Servers?
You can try SELECT * INTO command.
following is the syntax
SELECT * INTO table_name FROM database_server.database_name.dbo.table_name
before executing above query you need to linked the database servers.
for linking the databases use
sqlny1 <sqlny1@...> wrote:
We got a production database that gets
tables added to it daily.
So, every single day we transfer those new
tables via DTS to five (5) other servers (Each having the same database
I found no way to use the 'select' stmt across servers.
Can we accomplish this daily transfer by using a
I'm not conversant with TSQL (yet!) and
would very much appreciate any help you can
Thank you very much
To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre.