user schema issue

  • 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

  • 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?

    Hope this helps,
    Rich

    [p]
    [/p]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply