April 24, 2009 at 2:04 am
we have 100 sql server logins in sql 2000
we are migrating from sql server 2000 to sql server 2005
how do i export the logins to sql server 2005 database
does the passwords are valid in the sql server 2005
i need to export all logins to 2005 rather than creating one by one
its mere urgent
please some one help me out
regards
April 24, 2009 at 2:12 am
Script out the logins and execute the script in 2005 master database.
April 24, 2009 at 4:14 am
by using Transfer Logins Task package
and sp_change_users_login
Manoj
April 24, 2009 at 6:26 am
To transfer Windows and SQL Server Logins use the sp sp_help_revlogin
MS KB http://support.microsoft.com/kb/246133
Rajesh Kasturi
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply