October 13, 2010 at 1:51 am
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
October 14, 2010 at 6:51 am
OK, a couple of things:
Have you tried running DBCC commands on the newly upgraded databases?
It's generally a good idea to update statistics and check the integrity of the databases once they have been upgraded.
If you run SELECT * FROM Sys.Schemas do you see all the schemas you were expecting?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply