easiest way to get the name using OBJECT_ID?

  • 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?

    _________________________

  • OBJECT_NAME ( object_id )
  • 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