Hi,

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
name).

I found no way to use the 'select' stmt across servers.
Can we accomplish this daily transfer by using a
'Select' statement?

I'm not conversant with TSQL (yet!) and
would very much appreciate any help you can
give me.

Thank you very much


Mike

*** Sent via Developersdex http://www.developersdex.com ***

mike wrote:
Replied in microsoft.public.sqlserver.server

Please do not multi-post.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/m...S,SQL.90).aspx
--

Hi,

Am not sure whether this is best way to do it, but i know this is possible
way to do it.

You can use activeX task in DTS and can get the newly added tables using
below query
Select name from sysobjects where crdate = getdate()

Also create a global variage to hold the table name and this global variable
can be assigned with the table name retrieved using above query.

Now the DTS package will run based on the global variable.

Hope this helps.

Raj...



"mike" wrote: