Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MSSQL 2005 RTM and SP2 Expand / Collapse
Author
Message
Posted Thursday, December 15, 2011 5:51 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Thursday, December 15, 2011 6:09 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 11:14 AM
Points: 21,385, Visits: 9,603
SP2
Post #1222345
Posted Thursday, December 15, 2011 6:23 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Thursday, December 15, 2011 6:24 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 11:14 AM
Points: 21,385, Visits: 9,603
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
Posted Thursday, December 15, 2011 6:47 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Thursday, December 15, 2011 6:50 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 11:14 AM
Points: 21,385, Visits: 9,603
Script them from 2005 and run the script on 2008.

Google not working??
Post #1222397
Posted Thursday, December 15, 2011 6:59 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:45 AM
Points: 1,312, Visits: 2,490
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
Post #1222405
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse