General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi
I worked out that you have to implicitly use @LockOwner = 'Session', or you have to encapsulate the entire sp_getapplock/sp_releaseapplock code within a transaction. Typically, this requirement is not mentioned in any of Microsoft's SQL help files, I found this out via a search on the internet.
Regards
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only