Does sp_reset_connection cause my logon trigger to fire?
Hi, I am monitoring my sql server logins by using a simple trigger that fires on logon. On MSDN I have found that sp_reset_connection (which is used by
ADO.NET for connection pooling) also fires a Audit Login and Audit Logout event. This leads me to the following question, for which I can not find a clear answer yet: Does the sp_reset_connection cause my logon trigger to fire?
It is my understanding that if `sp_reset_connection` fires an Audit Login event, then it will also fire a logon trigger, based on the [MSDN/BOL entry] > Logon triggers fire stored procedures in response to a LOGON event. > .... > Note that the LOGON event corresponds to the AUDIT_LOGIN SQL Trace event But as Fatherjack has commented, surely this can be easily tested? :