I can't login on the server giving error: 17892.
I want to drop the trigger but , as soon as I tried to login, the trigger(Tr_ServerLogon) get executed
and login failed.
CREATE TRIGGER Tr_ServerLogon ON ALL SERVER FOR LOGON AS BEGIN INSERT INTO AuditDb.dbo.ServerLogonHistory SELECT SYSTEM_USER,USER,@@SPID,GETDATE() END GO /*Where 'Tr_ServerLogon' is trigger name */ /* AuditDb the database name which I have created. */
I have used following link with mine credentials but failed .
Here I am using SQL Authentication to logon to the server.
Can anybody suggest me the solution?