December 15, 2011 at 5:51 am
Which is upgraded product??
RTM or SP2???
Thanks & Regards,
Pallavi
December 15, 2011 at 6:09 am
SP2
December 15, 2011 at 6:23 am
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
December 15, 2011 at 6:24 am
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/
December 15, 2011 at 6:47 am
can you please tell me how to recreate the database users on server...
Thanks & Regards,
Pallavi
December 15, 2011 at 6:50 am
Script them from 2005 and run the script on 2008.
Google not working??
December 15, 2011 at 6:59 am
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:
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply