<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I am trying to automate SQL Login transfer from SQL2000 to SQL2005.<br />
The SQL2000 database is restored onto SQL2005 server every night.<br />
Once the db is restored, the db users will be orphaned.<br />
The following KB tells you how to transfer login with password but it doesn't seem to restore database mapping and its permission.<br />
<a href="http://support.microsoft.com/default.aspx?kbid=246133" rel="ugc">http://support.microsoft.com/default.aspx?kbid=246133</a><br />
<br />
Any help will be appreciated.
</div>
</div>


Hello,

I am trying to automate SQL Login transfer from SQL2000 to SQL2005.
The SQL2000 database is restored onto SQL2005 server every night.
Once the db is restored, the db users will be orphaned.
The following KB tells you how to transfer login with password but it doesn't seem to restore database mapping and its permission.
http://support.microsoft.com/default.aspx?kbid=246133

Any help will be appreciated.

SQL Login Transfer from SQL2000 to SQL2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.