Forum Discussion
Solved
Catch Error in a SQL Server Logon Trigger
I have written a Logon trigger in a SQL Server to control logon authorization. ALTER TRIGGER [LOG_TRG_01]
ON ALL SERVER WITH EXECUTE AS 'SA'
FOR LOGON
AS
BEGIN
if ORIGINAL_LOGIN() = 'sa'
begi...
Yes, base on my test, I think it's correct.
There is a code:
-- not allowed to logon
rollback;
It looks like you are using implicit transaction. It could be a reason. You can try to add BEGIN TRANSACTION before Insert ERROR_LOG, and COMMIT TRANSACTION after insert.
HI rodgerkong
I did put BEGIN TRANSACTION before and COMMIT TRANSACTION after Insert ERROR_LOG, but nothing changes.
1QfMtLF9KaR3D6ADF116F11111111740B4AF7D9B311113D3FE1E011111111C3CF49A83D951111116E2A54E68A6EE1EDE40F0B107D7F69E3FDD911E13DEB6EC308F711JH9EqC6NS