0
You cannot drop user because user '%1!' owns thresholds in database.
The user who created a threshold or last modified a threshold is the threshold owner. A user who owns a threshold cannot be dropped. Error 18033 occurs when you use sp_dropuser to try to drop a user who owns a threshold.
Use any of these three options:
Drop the threshold procedure owned by the user, then drop the user;
or:
Have another user with appropriate privileges modify the threshold, then drop the user;
or:
To inactivate the user Adaptive Server login while leaving the threshold active, use sp_locklogin to prevent use of the login.
See “sp_locklogin” in Reference Manual: Procedures for more information about using the sp_locklogin command.
All versions
