Post reply

select query issue

  • October 6, 2010 at 11:18 pm

    #229135

    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?

    Thanks a lot

    Regards

    Balaji.G

  • October 7, 2010 at 12:11 am

    #1233268

    Please check schema of your objects

    Ram
    MSSQL DBA

  • October 7, 2010 at 3:41 am

    #1233358

    Hi,

    while i'm restoring the database.. its just created the users and not to mapped the permissions.

    So in our instance, so many orphan users are there.. Can you pls give me a script

    to give the permissions for all db's users as per Source server strategy.

    Thanks

    Balaji.G

  • October 7, 2010 at 3:46 am

    #1233363

    You will need to move the logins across as well as these won't be part of the restore.

    Once you have moved the logins yuo can map them to the users in the databaseby using

    sp_change_users_login

    http://msdn.microsoft.com/en-us/library/ms174378.aspx

  • October 7, 2010 at 11:45 pm

    #1234032

    Hi Reo,

    This is for a childish question. but i don't know.. how to find out schema for all sql objects in sql2000 and sql 2008.

    if its schema vary.. what i will do..

    Thanks

    Balaji.G

  • October 8, 2010 at 4:18 am

    #1234126

    Pls check the collation.Is it case sensitive ?

Viewing 6 posts - 1 through 5 (of 5 total)

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