Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

object name from objid Expand / Collapse
Author
Message
Posted Thursday, December 4, 2008 2:38 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, December 4, 2008 10:01 PM
Points: 10, Visits: 28
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



Post #613493
Posted Thursday, December 4, 2008 2:47 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 4, 2014 7:44 AM
Points: 115, Visits: 646
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)
Post #613501
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse