Hi Jerry -
Why not use DTS and schedule the task to run on intervals. I think that
would be the easiest way to do things.
Jay
-----Original Message-----
From: Jerry Staple [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 12:16 PM
To: CF-Talk
Subject: SQL SERVER 7
Hi,
Could anyone give me any feedback on the following:
We have a SQL Server say for example "SQL1" based in Belfast, and
another SQL Server "SQL2" Based in London.
What i need to do is write a stored procedure from a database in "SQL1"
"Table1" to insert data into "SQL2" "Table2",i have a few ideas but any
tips and feedback would be most apreciated.
Thanks In Advance
Jerry Staple
Web Applications Developer
BizNet Solutions
133 - 137 Lisburn Rd
Belfast
BT9 7AG
Tel: +44 (0)28 9022 3224
Fax: +44 (0)28 9022 3223
www.biznet-solutions.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists