Post reply

Can''t find an Object listed in Activity Monitor

  • May 11, 2007 at 2:15 pm

    #116800

    In the Activity Monitor "Object ID" column I have an object ID of 72057594087473152 and on the same row the corresponding "Type" is given as Key. However when I query sysobjects for the his object id there are no matches.

    Any Hints or suggestions on how to track down this object or why I can't find it in sysobjects ?

    Thank you.

  • May 13, 2007 at 11:29 pm

    #706102

    Object ID is database specific. You have to query the database in which the object resides.

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply