Discussion on:
View:
Show:
I believe you left off the "END" at the end of the stored procedure code...
Hi,
I attempted to use the stored procedure, but an error stating: Msg 170, Level 15, State 1, Procedure sp_LockDetail, Line 38
Line 38: Incorrect syntax near 'APPLY'."
was returned.
Can someone please tell me what I'm doing wrong? Thank you.
I attempted to use the stored procedure, but an error stating: Msg 170, Level 15, State 1, Procedure sp_LockDetail, Line 38
Line 38: Incorrect syntax near 'APPLY'."
was returned.
Can someone please tell me what I'm doing wrong? Thank you.
Is there a way to find the first process starting the lock? I use sys.sysprocesses dmv, that shows blocked spid and I see many times multiple spids causing locking and often struggle to find out the first process, query that started it all.
Thanks
Thanks
- Keyboard Shortcuts:
- Prev
- Next
- Toggle
