This section discusses thresholds and how they are affected by locked user logins.
As a security measure, threshold stored procedures are executed using the account name and roles of the login that created the procedure.
You cannot drop the login of a user who owns a threshold.
If you lock the login of a user who owns a threshold, the user cannot execute the stored procedure.
The last-chance threshold, and thresholds created by the “sa” login are not affected by sp_locklogin. If you lock the “sa” login, the last chance threshold and thresholds created or modified by the “sa” user still fire.
