Erland Sommarskog (6/12/2014)

---

I'm afraid that I don't understand the question. If you are running a stored procedure, the logon trigger till not fire, because you are already logged in.

But if you attempt to log in with a disabled login, no this will not be recorded in by the trigger, because the trigger will not fire, since the login fails.

If you want to see failed logins for this GlobalLogin, you should make sure that SQL Server log failed login attempts to the SQL Server error log. (You do that in Object Explorer, right-click the server node, select Properties and then the Security page.)