A gud example mentioned using usage of Application locks. Application lock is a bit different than other kinds of SQL Server locks though. While other locks lock schema or data, application locks lock a part of your code. There are 2 stored procedure that are used for this: sp_getapplock and sp_releaseapplock.
Example here
July 15, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment