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

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 » How to transfer the logins and the passwords...

12 posts, Page 2 of 2

««1 2

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

Rate Topic

Display Mode

Topic Options

Author

Message

John Mitchell-245523

Posted Friday, December 16, 2011 4:11 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 9:14 AM
Points: 4,428, Visits: 7,196

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

pallavi.unde

Posted Friday, December 16, 2011 4:26 AM

SSC-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 »

12 posts, Page 2 of 2

««1 2

Permissions