Transfer Login

• Satya_0000

  Mr or Mrs. 500

  Points: 544

  More actions

  December 9, 2011 at 7:32 pm

  #253277

  Hi,

  I want to transfer logins from SQL server 2005 to new SQL server 2008. I need to transfer server level permissions as well.

  Thanks in advance.

• salum

  SSCommitted

  Points: 1598

  More actions

  December 9, 2011 at 7:35 pm

  #1419676

  You can use sp_help_revlogin to transfer the login. you can find the SP from below link.

  http://support.microsoft.com/kb/918992

  java[/url]