June 10, 2004 at 11:57 am
Weirdest thing ... I have a table in my DB not in sysobjects ... any idea why
June 10, 2004 at 12:25 pm
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:37 pm
Yes Sir ... Good Question. I'm the only one who asks dumb questions in this forum : )
June 10, 2004 at 1:10 pm
What happens if you run DBCC CHECKCATALOG in this database ?
June 10, 2004 at 1:32 pm
DBCC results for 'current database'.
DBCC execution completed.
June 10, 2004 at 1:46 pm
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 2:39 pm
I see it now with '%...' .. I had tried '...%'. Why?
June 11, 2004 at 8:56 am
the wildcard character implies that there's either a single (_) existing character or multiple (%) existing character where you've inserted the wildcard
instead of searching for table1 like '%1%' search for it like '%e%'
geez
Max
June 11, 2004 at 12:05 pm
Is there a way to see what character exists (which I can't see) before the first character of what I think is the table name?
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply