I am trying to work out a way to drop multiple users from the current database. I can use sp_dropuser but the limitation is one name_in_db at a time.
Have attempted to use cursors but get the following error,
"The procedure 'sp_revokedbaccess' cannot be executed within a transaction."
Any suggestions how i can overcome this hurdle.