Odd "Cannot find a table or object" error

• alex-746374

  SSC Eights!

  Points: 922

  More actions

  August 14, 2009 at 3:43 am

  #156108

  I run this code to create a temp table:

  CREATE TABLE #EID ( ID INT, Ename VARCHAR(10) )

  INSERT INTO #EID ( ID, Ename )

  SELECT 1, 'hello'

  SELECT * FROM #EID

  DBCC DBREINDEX( #EID, ' ',90)

  The last line gives me:

  Msg 2501, Level 16, State 45, Line 8

  Cannot find a table or object with the name "#EID". Check the system catalog.

  but clearly this exists. I'm porting code from sql server 2000 to 2005. Is this a stupid error message and the problem is actually somewhere else?

• Ian Scarlett

  SSC-Insane

  Points: 23197

  More actions

  August 14, 2009 at 4:02 am

  #1039229

  Another subtle difference between SQL 2000 and SQL2005. Try this:-

  CREATE TABLE #EID ( ID INT, Ename VARCHAR(10) )

  INSERT INTO #EID ( ID, Ename )

  SELECT 1, 'hello'

  SELECT * FROM #EID

  DBCC DBREINDEX( 'tempdb..#EID', ' ',90)

• alex-746374

  SSC Eights!

  Points: 922

  More actions

  August 14, 2009 at 4:06 am

  #1039232

  Brilliant - that's it. (I actually tried that without the quotes).

  Thanks!