A logon trigger, as the name suggests, is a trigger that fires in response to a LOGON event in SQL Server.
In simple terms, a logon trigger fires whenever someone tries to establish a new connection to a database server. The trigger fires after the user authentication and the login phase completes but before the user session is actually initiated. Read More