craziness, what about select * from sysobjects where [name] like '%XXXXX%'

Where XXXXX is the name of the table you are looking for

What happens if you run DBCC CHECKCATALOG in this database ?

Just to check the obvious first , you are in the same db as the table when you select from sysobjects?

http://www.microsoft.com/sql/techinfo/tips/administration/changingdbo.asp

Quote:

You can change the dbo to the sa from the Windows NT login. The fastest way to do this is to detach the database, then reattach it while...

If you are trying to find the records that are in abc_commerce.dbo.UserObject and not in test2.dbo.UserObject try this :

Left join so you have access to all the primary tables records...