Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 189
  • Last Modified:

How to Backup existing users privilege for database in SQL Server 2005?

Hi All,
I am doing a data refresh on my SQL 2005 database.
So I want to backup all my logins on current 2005 database to restore them later after done with the data refresh on it.

Can some one provide me the script for SQL 2005?
Thanks!
 
0
msdba
Asked:
msdba
3 Solutions
 
lcohanDatabase AnalystCommented:
How to transfer logins and passwords between instances of SQL Server

http://support.microsoft.com/kb/246133 
0
 
msdbaAuthor Commented:
Thanks!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now