Transfer logins, passwords, db users, db permissions from sql 2000 to sql2008

• Fishbarnriots

  SSCrazy

  Points: 2568

  More actions

  September 28, 2009 at 10:08 am

  #210201

  Dear all,

  I have a lovely stored proc that will create a script capable of creating server logins, database users, transfer passwords, and permissions between instances of SQL 2000, what I am in need of is a similar script that will do the same between SQL 200 and SQL 2008 (current script is falling over all over the place)

  Does such a script exist, or is there a better method that I am missing??

  Cheers

• ggoble

  Hall of Fame

  Points: 3337

  More actions

  September 30, 2009 at 4:08 pm

  #1060217

  In Visual studio use the Transfer login task and set copy sids = true. It is under Integration Services project.