Executing the procedure with parameters @DBNAME = 'database_name' , @USERS = 'ALL' and @EXCEPT = '' deletes all users from the specified database without any exceptions. The output shows the users name that have been deleted and their owned schemas.

Example:

EXEC REMOVE_USERS_2000_and_2005 @DBNAME ='Products', @USER = 'ALL', @EXCEPT = ''
GO


Results: