Hi All,
Our Scenario is we can upgrade from sql 2000 to 2008 server.
I restore sqlserver 2000 db's to sqlserver 2008 express edition client tools.Then i change the
compatablilty mode.
I used to select * from sysobjects query..
Some of the objects comes under dbo schema and some of the objects comes under user schema..
when i ran the dbo schema objects using select query.. it's executed and
if i ran the user schema objects, it shows invalid object name.
I had checked the source server like sql 2000 dev server.. User schema objects ran successfully
using normal select query.
Can you pls advise me.. where is the problem occurs.. how can i fix it?
Regards
Balaji.G