>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

Have you declared @lnLock as int ?