Remote Stored Procedures
You can execute a stored procedure residing on another server by using a four-part naming scheme:
EXEC server_name.db_name.owner_name.proc_name
This concept is called remote stored procedures (RPCs). The name implies that the procedure called on the other server is a special type of stored procedure, but it is not. Any stored procedure can be called from another server as long as the remote server has been configured and the appropriate login mapping has been done. The method used to set up servers to allow remote procedure calls is described in Chapter 19, “Managing Linked and Remote Servers.”
The processing done by the remote stored procedure is, by default, not done in the local transaction context. If the local ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
