TERMS OF USE
 
  Contact Importer Main Page
 
 

- Delete ALL users from a database

 
 

- Delete given users from a database

 
  - Delete ALL users from a database excepting some  
  Delete Users SP See It Working
  Purchase Delete Users SP
  Delete Users SP Clients Support
 
  Delete Database Users stored procedure :: See It Working  
 

You can easy clean up your database of unnecessarily users by using this stored procedure:
 
 



Executing the procedure with parameters @DBNAME = 'database_name' , @USERS = 'ALL' and @EXCEPT = '' deletes all users from the specified database without any exceptions.

View screenshots Here




Executing the procedure with parameters @DBNAME = 'database_name' , @USERS = 'ALL' and @EXCEPT = 'list_user_exception' deletes all users from the specified database excepting the users specified in the @EXCEPT parameter.

View screenshots Here





Executing the procedure with parameters @DBNAME = 'database_name' , @USERS = 'list_users' and @EXCEPT = '' deletes the specified users given in the @USERS parameter.

View screenshots Here



 
 
Need a Remote DBA?  Click here for our Remote Database Services.
 
2BM Remote Database Services