MSSQL Extended Stored Procedures

Extended stored procedures can be built to perform functionality not possible with Transact-SQL stored procedures. Extended stored procedures can, however, compromise the integrity of the SQL Server process, while managed code that is verified to be type-safe cannot. Further, memory management, scheduling of threads and fibers, and synchronization services are more deeply integrated between the managed code of the CLR and SQL Server. With CLR integration, you have a more secure, scalable way than extended stored procedures to write the stored procedures you need to perform tasks not possible in Transact-SQL

Leave a Reply

Your email address will not be published. Required fields are marked *