June 17, 2008 at 12:22 am
Hi Group,
I have a database in SQL Server 2000 Standard Edition, I am now migrating that into SQL Server 2005 SP2 x64.
I have atleast 50 database users login with the database, can anyone help me how to take backup and restore the database logins so that i can see these in the security logins under object explorer of SQL Server 2005's Management studio. I noticed that these logins shows in the database's Security Logins but not in SQL Server's Security Logins.
Now what how can i restore the complete set of those 50 users.
Advance thanks
regards
June 17, 2008 at 2:00 am
You can make use of sp_help_revlogin procedure to perform that,http://support.microsoft.com/kb/246133
[font="Verdana"]- Deepak[/font]
June 17, 2008 at 7:16 am
You could also script out the logins and users from the 2000 server and run the script on the 2005 instance.
Gethyn Elliswww.gethynellis.com
June 17, 2008 at 9:51 am
thanks deepak....
July 22, 2008 at 1:25 pm
Thank you Deepak, it helped me too !
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy