InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 12:37:44 GMT20http://www.sqlservercentral.com/Forums/Topic613493-5-1.aspxIf you want get object_name using object_id.you can use the following commandselect object_name(object_id)ex:select object_name(1000)Thu, 04 Dec 2008 02:47:25 GMTbrainyhttp://www.sqlservercentral.com/Forums/Topic613493-5-1.aspxHi,i am new to sql server 2000:from last 5 hours one of the perl script is showing RUNNABLE(sp_who2) in database and for that particular spid i can see 3 objid(sp_lock) anybody help me out to find object name from objid. and mode lock is Sch-S is i need to worry about this mode of lock.ThanksPrakash Thu, 04 Dec 2008 02:38:26 GMTprakash.gr