How Extended Stored Procedures Work
SQL Server 2000
The process by which an extended stored procedure works is:
- When a client executes an extended stored procedure, the request is transmitted in tabular data stream (TDS) format from the client application through the Net-Libraries and Open Data Services to Microsoft® SQL Server™.
- SQL Server searches for the DLL associated with the extended stored procedure, and loads the DLL if it is not already loaded.
- SQL Server calls the requested extended stored procedure (implemented as a function inside the DLL).
- The extended stored procedure passes result sets and return parameters back to the server by using the Open Data Services API.