Objects Not In Database But Listed in SysObjects - Huh?

[fuzzyocelot]

Hey everyone!

I implemented a new test database (SQL 2000) onto one of our servers by restoring the backup file provided to us by a vendor. I then ran a script (also provided by the vendor) to dynamically grant the execute permission to the 300+ user-defined stored procedures and functions by reading their names from the sysobjects table for the test database. The script ran fine with a few exceptions.

Of those stored procedures, it couldn’t find 4 to them. I thought this was strange. These stored procedures are listed in the sysobjects table, but are not in the database at all.

How can this be? It doesn’t make sense to me. Can anyone explain how this can happen?

Thanks!

 

[fuzzyocelot]

Nevermind! It turns out the objects in question had a different schema which was at the bottom of the list. I didn't see it until someone pointed it out to me. Doh!