Hello friends in this video I have explained logon trigger with scenario and practical example.
What is trigger: https://youtu.be/0bJLtxvXEx8
DDL trigger: https://youtu.be/Q3WNiqwHvTc
DML trigger: https://youtu.be/pvXihXkHSA0
Logon Trigger : https://youtu.be/b8jQqGyQnRY
covered below points
1 what is logon trigger
2. use of logon trigger
3. how we can create logon trigger
Logon triggers fire stored procedures in response to a LOGON event. This event is raised when a user session is established with an instance of SQL Server. Logon triggers fire after the authentication phase of logging in finishes, but before the user session is actually established. Therefore, all messages originating inside the trigger that would typically reach the user, such as error messages and messages from the PRINT statement, are diverted to the SQL Server error log. Logon triggers do not fire if authentication fails.
You can use logon triggers to audit and control server sessions, such as by tracking login activity, restricting logins to SQL Server, or limiting the number of sessions for a specific login. For example, in the following code, the logon trigger denies log in attempts to SQL Server initiated by login login_test if there are already three user sessions created by that login.
