Fix Orphan Users

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  November 22, 2016 at 5:24 pm

  #337802

  Comments posted to this topic are about the item Fix Orphan Users

  Thanks.

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  November 30, 2016 at 8:40 am

  #1915186

  Interesting script. I need to look at this a little closer. I do see that you have it so you can just print out results by swapping which lines are commented.

• Ant-Green

  SSC Guru

  Points: 113544

  More actions

  January 26, 2017 at 2:05 am

  #1925015

  Good script, I would however change sp_change_users_login to ALTER LOGIN instead as the former is marked for depreciation in a later release of the product, just to ensure continued support with the new ALTER method.