I am trying to create this trigger but I am getting an error... I am working in SQL Server 2005 but really the trigger is going to be created in SQL Server 2000.
create trigger dbo.trigger_login_registers
insert into dbo.login_registers values
(SYSTEM_USER, CURRENT_USER, getdate(), host_name());
The error is the following:
Msg 1084, Level 15, State 1, Procedure trigger_login_registers, Line 3
'logon' is an invalid event type.
I am checking the sintaxis and according to it, All is fine...