MSSQL 2005 RTM and SP2

  • pallavi.unde

    SSCommitted

    Points: 1987

    Which is upgraded product??

    RTM or SP2???

    Thanks & Regards,
    Pallavi

  • Ninja's_RGR'us

    SSC Guru

    Points: 294069

    SP2

  • pallavi.unde

    SSCommitted

    Points: 1987

    Currently i am using MSSQL 2005 in which i have given the permission to the different database users..

    Now I wanted to install MSSQL 2008... doubt is here that if i restore a databases in MSSQL 2008 then can i use the permission which i set previouse in MSSQL 2005 version??????

    or do i need to set the permission again???

    Which is the good service pack in MSSQL 2008????

    Thanks & Regards,
    Pallavi

  • Ninja's_RGR'us

    SSC Guru

    Points: 294069

    You need to recreate the users on the new server, but then the permissions on the db level should work.

    Build list :

    http://www.sqlservercentral.com/articles/SQL+Server+2008/63491/

  • pallavi.unde

    SSCommitted

    Points: 1987

    can you please tell me how to recreate the database users on server...

    Thanks & Regards,
    Pallavi

  • Ninja's_RGR'us

    SSC Guru

    Points: 294069

    Script them from 2005 and run the script on 2008.

    Google not working??

  • Divine Flame

    SSCoach

    Points: 15941

    pallavi.unde (12/15/2011)


    can you please tell me how to recreate the database users on server...

    Ninja's_RGR'us (12/15/2011)


    Google not working??

    Nice one Ninja 😀

    However, if you are still not able to find it on google, check this:

    How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008


    Sujeet Singh

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

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