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