Invalid Object Name

Greetings
I have recently migrated several databases from SQL 7 to SQL 2000. When
accessing one table in one database with a simple SQL statement (SELECT *
FROM tablename) I am receiving error -2147217865-Invalid object name
'tablename'.
Is this related to the migration to SQL 2000 from SQL 7? I have recreated
the table, but still receiving the same error.
Thank you for any insight and help you can provide.
Sidney Mark CroyTwo questions -
1) Does 'tablename' actually exist in the database?
2) Assuming you're using Query Analyzer, are you in the right database
(check the drop-down list up top)?
3) Is 'tablename' a standard ANSI name? If not, try putting brackets [
]
around it
4) Is the database marked suspect, offline, or any of that good stuff?
5) Are you using the same collation on your SQL 2K server as on SQL 7?
Thanks,
Michael C.
"Sidney Mark Croy" <smcroy@.hotmail.com> wrote in message
news:eldKVP3aEHA.2812@.TK2MSFTNGP11.phx.gbl...
> Greetings
> I have recently migrated several databases from SQL 7 to SQL 2000. When
> accessing one table in one database with a simple SQL statement (SELECT *
> FROM tablename) I am receiving error -2147217865-Invalid object name
> 'tablename'.
> Is this related to the migration to SQL 2000 from SQL 7? I have recreated
> the table, but still receiving the same error.
> Thank you for any insight and help you can provide.
> Sidney Mark Croy
>|||Greetings
The tablename actually exists, and the query is pointing to the correct
database. The database is not marked suspect, offline, etc.
"Michael C" <nospam@.lol.net> wrote in message
news:vJiKc.32650$Kz3.3168666@.news4.srv.hcvlny.cv.net...
> Two questions -
> 1) Does 'tablename' actually exist in the database?
> 2) Assuming you're using Query Analyzer, are you in the right database
> (check the drop-down list up top)?
> 3) Is 'tablename' a standard ANSI name? If not, try putting brackets [
; ]
> around it
> 4) Is the database marked suspect, offline, or any of that good stuff?
> 5) Are you using the same collation on your SQL 2K server as on SQL 7?
> Thanks,
> Michael C.
> "Sidney Mark Croy" <smcroy@.hotmail.com> wrote in message
> news:eldKVP3aEHA.2812@.TK2MSFTNGP11.phx.gbl...
*[vbcol=seagreen]
recreated[vbcol=seagreen]
>