Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > SQL Language
| Search | Today's Posts | Mark Forums Read
SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old September 15th, 2005, 06:03 AM
Registered User
 
Join Date: Sep 2005
Location: Craiova, , Romania.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default calling a store procedure from another server

Hy

Has any of you an idea of how to call a stored procedure (or many) from another SQL server instance (from a different computer)? - I have the username and password of the other sql server and the IP of the computer that instance is running on.

Ex. computer 1 - sql server 1 - proc1
 computer 2 - sqlserver2 - proc2

proc2 - calls proc1...for example


HElP


Thank you very much

Amalia






Floriana P
  #2 (permalink)  
Old September 15th, 2005, 06:52 AM
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Store procedure help... RinoDM SQL Server 2000 7 August 11th, 2008 07:09 PM
Store procedure help ??? RinoDM SQL Server 2000 8 May 1st, 2008 03:03 PM
Calling Store Procedure in the PHP Code malay mehta MySQL 0 July 11th, 2007 09:06 AM
MS SQL SERVER STORE PROCEDURE and schedulling kumiko Classic ASP Basics 2 June 8th, 2007 01:03 AM
Store Procedure sureshyuga SQL Server 2000 0 May 18th, 2007 01:49 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.