How Extended Stored Procedures Work

The process by which an extended stored procedure works is:

1. 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™.
2. SQL Server searches for the DLL associated with the extended stored procedure, and loads the DLL if it is not already loaded.
3. SQL Server calls the requested extended stored procedure (implemented as a function inside the DLL).
4. The extended stored procedure passes result sets and return parameters back to the server by using the Open Data Services API.