Script needed! help

• twebster

  Newbie

  Points: 1

  More actions

  June 20, 2008 at 4:23 am

  #381222

  Hey gents!

  I need a script for deleting users from mulpitple databases can anyone help?

• Jeff Moden

  SSC Guru

  Points: 1004356

  More actions

  June 20, 2008 at 8:13 am

  #831794

  Google sp_MSForEachDB.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• MannySingh

  SSChampion

  Points: 12465

  More actions

  June 20, 2008 at 9:15 am

  #831880

  sp_msforeachdb @command1='USE ? DELETE from sysusers where name ='' '' '

  something like this.. Or use Cursor to scroll through each DBNAMe and Delete the user in the Database...(each DB).

  Declare @dbnamehold sysname

  declare getdbname cursor for

  select name from master.dbo.sysdatabases where dbid>4

  open getdbname

  fetch next from getdbname into @dbnamehold

  while @@fetch_Status=0

  BEGIN

  select @dbnamehold,name from sysusers where name like '% %'

  Fetch next from getdbname into @dbnamehold

  END

  close getdbname

  deallocate getdbname

  Maninder
  www.dbanation.com