View Single Post
 
Old September 15th, 2005, 06:52 AM
Jeff Mason Jeff Mason is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Hudson, MA, USA.
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

This is the SQL Language forum. The specifics of how you do this, or if you can do it at all, will depend on your specific product.

In SQL Server, the simplest way to do this is via a linked server. A stored procedure on one system can invoke another by using the EXEC statement and using a fully qualified name which would specify the particular server for the stored procedure to be invoked.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com