Is it possible to use SSMS to send a procedure call as an RPC event rather than a SQL batch?
I have tried
asked Jun 12, 2011 at 09:05 AM in Default
The CALL statement can be used for executing stored proc using the ODBC driver for SQL Server. See How to: Call Stored Procedures (ODBC). So to use the Call Syntax you need to connect to the SQL Server using an ODBC Driver.
You can simulate this in SSMS by registering a System ODBC DSN to your server. Then you can create a linked server using an OLEDB provider for ODBC Drivers and use the OPENQUERY to execute the stored procedure using the CALL statement