script for del users

• geetha@in

  Ten Centuries

  Points: 1235

  More actions

  January 20, 2011 at 3:54 am

  #233443

  Hi All,

  when iam deleting the login ,automatically user also deleted in GUI....

  So I want t-sql script for automatically delete the user when i delete the login belongs to that user..

  Thanks to all...

• Portes Ysaias

  SSCrazy

  Points: 2144

  More actions

  April 12, 2011 at 7:29 pm

  #1310778

  This script should work just fine:

  You may want to modify it a little so it first checks if the user exists:

  drop Login [login_name]

  go

  sp_msforeachDB 'Use [?]; DROP USER [user_name];'

  Ysaias Portes | Forward Thinkers Consulting
  sp_SQLFlightRecorder — open-source SQL Server diagnostic recorder | forwardthinkersconsulting.com