• Assuming none of the users own schemas or objects, this will generate the commands for you. Edit as needed:

    select 'drop user [' + d.name + ']'

    from sys.database_principals d left join

    sys.server_principals s on d.sid = s.sid

    where d.type = 'U'

    and s.sid is null