"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
>
>

"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...
> > 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
> >
> >
>
>