His default database is set to "test" database.

The process is adhoc. The users can start this process any time of the day. I have talked with the developer about the options of a logical delete. Then creating...

Yes, the delete operation is to intense. They are deleting millions of rows and this could happen numerous times a day effecting online users response times.

The user was in another group. I ended up removing database access privileges to find out what group the id was in. Then discovered the group had individual grants on...

Yes we do have 'BUILTIN\Administrators' in the sql server database but these users are not in the administrator group. I am going to have them login and run the sp_who2...