How to determine sql server object name from object id and database id (sql2000)?

Posted by Tomek on Stack Overflow See other posts from Stack Overflow or by Tomek
Published on 2010-05-29T13:10:42Z Indexed on 2010/05/29 13:12 UTC
Read the original article Hit count: 313

Filed under:
|

I need the behaviour of sql2005 where function OBJECT_NAME takes two arguments obj id and db id, while sql2000 takes only obj id so the execution must be in the context of the database to which inspected object belongs to. Solution must be possible to implement in a function, so it can be used in a select query.

© Stack Overflow or respective owner

Related posts about object

Related posts about name