Thank you all for the time and effort put into trying to understand and fix this issue. I will see what I can get past my boss and play with...

the object shows up in the sys.procedures view as #mytest.

I would also like to add that I am logged in as a sysadmin.

The extra "00" is added due to the...

• This reply was modified 3 years, 11 months ago by  Brian Alger.
• This reply was modified 3 years, 11 months ago by  Brian Alger.

Had not thought about that road.  Here is what that script produced:

CAST([name] AS VARBINARY(MAX)) = 0x23006D0079007400650073007400

CAST('#mytest' AS VARBINARY(MAX)) = 0x236D7974657374

Other than the extra zeros they match.

It is showing up under Stored Procedures in one of our databases, not the tempdb database.  This object has remained in existence through our server upgrades to SQL 2005, SQL...