object name from objid

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » object name from objid

object name from objid

Rate Topic

Display Mode

Topic Options

Author

Message

prakash.gr

Posted Thursday, December 04, 2008 2:38 AM

Grasshopper

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

brainy

Posted Thursday, December 04, 2008 2:47 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 113, Visits: 625

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 »

Permissions