Thursday, December 12, 2013

Thread locking in SQL Server

I just discovered a cool system stored procedure in SQL Server.

sp_getapplock allows you to do thread locking in T-SQL without creating surrogate DB objects.

No idea why this is not better known.