Finding object name from object id in SQL 2000

This is actually a use of an undocumented SP. Using below code you will be able to find the object name from the numeric object id value:

USE [DatabaseName]

GO

declare @object_id int, @qualified_name nvarchar(512)

select @object_id = [ObjectID]

EXEC sp_MSget_qualified_name @object_id, @qualified_name output

select @qualified_name

GO