sql server migration issues RRS feed

  • Question


    We recentely tried migrating our databases from 2000 to sql server
    2005.The migrated databases had some issues like collation issues,so
    we created the scripts for each databases and then updated these
    scripts to remove collation issues to make these compatible to SQL
    server 2005.
    But we have some permission issues for the users in case of these
    created databases i.e. we are unable to see all the tables with
    ssupdate user id ,or any other id .except the dbo id
    which is the owner of this database,where we can see all the tables
    and stored procedures.
    iam fairly new at sql server .does anyone have any suggestions or
    critcisms ?
    you are welcome.
    Wednesday, February 6, 2008 12:36 PM


All replies