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

Reply via email to