object name from objid

• prakash.gr

  SSC-Addicted

  Points: 428

  More actions

  December 4, 2008 at 2:38 am

  #75379

  Hi,

  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.

  Thanks

  Prakash

• brainy

  SSCrazy

  Points: 2445

  More actions

  December 4, 2008 at 2:47 am

  #907430

  If you want get object_name using object_id.

  you can use the following command

  select object_name(object_id)

  ex:

  select object_name(1000)