December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 Unleashed
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Executing a Stored Procedure via a Linked Server
Executing a stored procedure is possible via a linked server. The server hosting the client connection accepts the client’s request and sends it to the linked server. The EXECUTE statement must contain the name of the linked server as part of its syntax:
EXECUTE servername.dbname.owner.procedure_name
The following example executes the sp_helpserver system stored procedure on the linked server 'DATAXDESIGN-PC\SQL2012DXD02', which simply shows the server configuration information on that remote server:
EXEC [DATAXDESIGN-PC\SQL2012DXD02].[master].[dbo].[sp_helpserver]
The final example executes the user-created stored procedure on the remote ...