SQL Server 7.0 I need SP to copy tables between dbs on diff. domains

[brettz]

I am trying to copy tables from a database on one domain to a database on another domain. I have both servers and respective databases registered in my SQL Server 7.0 Enterprise Manager.

Is this possible? If so, can you give me some direction?

Thanks,

-Brett

 

[tlbroadbent]

If you can access both databases in Enterprise Manager, create a DTS package to perform the transfer. SQL BOL contains details of DTS and the wizards are rather easy to use. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/programmer.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[brettz]

I apoloize...I did not make myself very clear. My problem is not in creating the DTS package or copying the databases. What I need is a way to create a Stored Procedure and a trigger in order to automatically have this copying of dbs between servers done every day at a set time. Is this possible? If so, I would greatly appreciate any help.

Thanks,

-Brett