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 ««12

How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008 Expand / Collapse
Author
Message
Posted Friday, December 16, 2011 4:11 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:52 AM
Points: 5,078, Visits: 8,923
Marco V (12/16/2011)

anyways his typo in the alter login



ALTER USER ram WITH LOGIN = ram


Yes indeed. It was an error in the code that I posted, but I did make clear that I was doing it from memory. The OP got a syntax error but made no attempt to find out what the correct syntax should be. That's why I don't post back with the correct syntax - the best way for most people to learn is by doing it for themselves.

John
Post #1222946
Posted Friday, December 16, 2011 4:26 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
It's working now :)

Thank you...




Thanks & Regards,
Pallavi
Post #1222950
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse