From time to time I've considered making a call from a SQL Server stored proc into a .NET assembly via COM Interop using the sp_OA stored procedures as a mechanism to perform some database triggered activity (say from a scheduled job). I've always found a different solution in the end and it turns out to have been lucky that I did so:

Q322884 - INF: Using Extended Stored Procedures or SP_OA Stored Procedures to Load CLR in SQL Server Is Not Supported

To increase performance, the CLR internally uses thread-local-storage (TLS) which isn't allowed inside the SQL Server memory space. In addition, SQL may be configured to use fibers, which the CLR additionally doesn't support.

posted on Wednesday, May 21, 2003 3:21 PM |
Comments have been closed on this topic.