Viewing 5 posts - 1 through 5 (of 5 total)
craziness, what about select * from sysobjects where [name] like '%XXXXX%'
Where XXXXX is the name of the table you are looking for
June 10, 2004 at 1:46 pm
#509963
What happens if you run DBCC CHECKCATALOG in this database ?
June 10, 2004 at 1:10 pm
#509958
Just to check the obvious first , you are in the same db as the table when you select from sysobjects?
June 10, 2004 at 12:25 pm
#509947
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...
June 10, 2004 at 10:41 am
#509921
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...
June 10, 2004 at 8:20 am
#509879