Saturday, January 29, 2011

Re-generating SQL Server Logins

Migrating database servers is quite a frequent task which is carried out by a DBA. In migrating, it is very important to transfer the logins. When transfering logins and users, you need to make sure that you transfer roles and password as well.
By querying the system tables, database administrators can produce a comprehensive report for login permission including original password, the server and database roles assigned, down to granular level object permission.
This article describes how to achive this and other information behind this.

No comments:

Post a Comment