Post reply

easiest way to get the name using OBJECT_ID?

  • August 1, 2007 at 8:23 am

    #174665

    whats the best way to get the object name from the Object_ID?

    i've got an object id, and i can do a quick join against sysobjects

    using the object_id etc to find the name, but isn't there a way

    i can use the OBJECT_ID function or something like that?

    _________________________

  • August 1, 2007 at 8:58 am

    #723901 

    OBJECT_NAME ( object_id )

  • August 1, 2007 at 10:15 am

    #723943

    no BOL installed then ?

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

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

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