Hi

I'm using the following code in my SQL procedure:

exec @lnLock = sp_getapplock @Resource = 'MyResource', @LockMode ='Shared'
return @lnLock

@lnLock always returns -999, which suggests a syntax error. However, if I removed the @lockmode part, the statement doesn't error. Any ideas?

Regards