MSSQL 2005 RTM and SP2

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Compact Edition » MSSQL 2005 RTM and SP2

MSSQL 2005 RTM and SP2

Rate Topic

Display Mode

Topic Options

Author

Message

pallavi.unde

Posted Thursday, December 15, 2011 5:51 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 14, 2013 5:35 AM
Points: 191, Visits: 170

Which is upgraded product??
RTM or SP2???

Thanks & Regards,
Pallavi

Post #1222337

Ninja's_RGR'us

Posted Thursday, December 15, 2011 6:09 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 3:18 AM
Points: 21,359, Visits: 9,541

SP2

Post #1222345

pallavi.unde

Posted Thursday, December 15, 2011 6:23 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 14, 2013 5:35 AM
Points: 191, Visits: 170

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

Post #1222362

Ninja's_RGR'us

Posted Thursday, December 15, 2011 6:24 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 3:18 AM
Points: 21,359, Visits: 9,541

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/

Post #1222365

pallavi.unde

Posted Thursday, December 15, 2011 6:47 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 14, 2013 5:35 AM
Points: 191, Visits: 170

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

Thanks & Regards,
Pallavi

Post #1222393

Ninja's_RGR'us

Posted Thursday, December 15, 2011 6:50 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 3:18 AM
Points: 21,359, Visits: 9,541

Script them from 2005 and run the script on 2008.

Google not working??

Post #1222397

Divine Flame

Posted Thursday, December 15, 2011 6:59 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 5:48 AM
Points: 1,076, Visits: 1,922

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 BigGrin

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

- Divine Flame

Post #1222405

« Prev Topic | Next Topic »

Permissions