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 04, 2008 2:38 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, December 04, 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 04, 2008 2:47 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, November 27, 2013 10:25 PM
Points: 113, Visits: 638
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