SQL Server Performance Forum – Threads Archive

Sp_lock (SP_ID)

Hi,<br /><br />There is one very interesting thing I have observed. Eventhough I have not used this table (Hold_Withdrawal_Item_Fund) and related table for last some months…I am getting this in the result when I do a query:<br /><br />Sp_lock (SP_ID)<br />Result – 1115151018<br /><br />select object_name(111515101<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /><br />Result – Hold_Withdrawal_Item_Fund<br /><br />Ashish Johri

---

Run the query against master..sysprocesses table to see the origin of the SPID…
You are not using but may be some one else…
MohammedU.
Moderator
SQL-Server-Performance.com

---

]]>