Server: Msg 208, Level 16, Line 1

Question

Server: Msg 208, Level 16, Line 1

kinzent

SSChasing Mays

Points: 621
More actions
March 28, 2010 at 7:23 pm

#222552

When I select the name from sys.objects ,I can find the table exists.
But the table does not exist actually.
Is somebody can tell me why?
use mydb
select * from sys.objects where type='U' and name like '%TempICItemReplaceEntryEC0FAA5F3AA14B6E8108299DB071%'
TempICItemReplaceEntryEC0FAA5F3AA14B6E8108299DB0715E3A7155774NULL10U USER_TABLE2009-12-07 18:57:50.3802009-12-07 18:57:50.380000
select * from TempICItemReplaceEntryEC0FAA5F3AA14B6E8108299DB071
message 208 level 16 status 1
Server: Msg 208, Level 16, Line 1
Invalid object name 'TempICItemReplaceEntryEC0FAA5F3AA14B6E8108299DB071'
---------------------------------------
Thorn Bird...

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

kinzent (3/28/2010)
When I select the name from sys.objects ,I can find the table exists.
But the table does not exist actually.
Is somebody can tell me why?
use mydb
select * from sys.objects where type='U' and name like '%TempICItemReplaceEntryEC0FAA5F3AA14B6E8108299DB071%'
TempICItemReplaceEntryEC0FAA5F3AA14B6E8108299DB0715E3A7155774NULL10U USER_TABLE2009-12-07 18:57:50.3802009-12-07 18:57:50.380000
select * from TempICItemReplaceEntryEC0FAA5F3AA14B6E8108299DB071
message 208 level 16 status 1
Server: Msg 208, Level 16, Line 1
Invalid object name 'TempICItemReplaceEntryEC0FAA5F3AA14B6E8108299DB071'

What about this:

select * from TempICItemReplaceEntryEC0FAA5F3AA14B6E8108299DB0715E3A;

Paul White SSC Guru Points: 150467 More actions · Answer 2

Also, consider using sys.tables

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi