January 26, 2007 at 1:18 pm
How do I retrieve all users (both Windows & SQL) and their access rights on a SQL Server.
Thank you.
Answer: exec sp_helpuser
Is there a script by which I can move all the logins and the access rights to 2005 environment.
I have already backed up and restored the databases from 2000 to 2005.
Let me know if I am doing something wrong.
Thank you.
January 26, 2007 at 1:35 pm
May be you are looking for this...
How to transfer logins and passwords between instances of SQL Server
http://support.microsoft.com/kb/246133
MohammedU
Microsoft SQL Server MVP
January 26, 2007 at 1:38 pm
I am trying to move logins/users from 2000 to 2005.
January 26, 2007 at 11:25 pm
Use the link in my previous reply to move the logins from 2000 to 2005...
MohammedU
Microsoft SQL Server MVP
January 27, 2007 at 11:09 am
Thanks, this is what I was looking.
January 27, 2007 at 11:32 am
I use this all the time to move logins from 2000 to 2000/2005...
Note: You may need to set the default dbs sometimes...
MohammedU
Microsoft SQL Server MVP
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply