Need the old SQL 2000 sidmap script !!!

• Express12

  SSCoach

  Points: 18526

  More actions

  July 3, 2008 at 6:42 am

  #184283

  I realize this is the 2005 Admin forum BUT -- thought I'd tap my fellow peers for the OLD SQL "2000" sidmap script that operates on a single DB (or preferrably a supercharged version that navigates all DB's) and remaps LOGINS to USERS.

  thanks in advance

  BT

• Balmukund

  SSCertifiable

  Points: 6648

  More actions

  July 3, 2008 at 7:01 am

  #837806

  This?

  http://blogs.msdn.com/blakhani/archive/2008/02/25/script-map-all-orphan-users-to-logins-else-create-login-and-map.aspx

• Express12

  SSCoach

  Points: 18526

  More actions

  July 3, 2008 at 7:10 am

  #837815

  Yes. Also: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=37335

  BT