Error : CREATE TRIGGER test ON DATABASE FOR ALTER_LOGIN

• onlo

  SSCertifiable

  Points: 5080

  More actions

  January 7, 2014 at 2:50 am

  #281763

  I failed to create trigger in a SQL 2005 environment:

  CREATE TRIGGER test01 ON DATABASE FOR ALTER_LOGIN

  AS BEGIN

  SET NOCOUNT ON;

  INSERT dbo.test03 (db_name, host_name, user_name, datetime)

  SELECT DB_NAME(), HOST_NAME(), SUSER_NAME, GETDATE();

  END

  Msg 1098, Level 15, State 1, Procedure test01, Line 8

  The specified event type(s) is/are not valid on the specified target object.

  However, this one is OK:

  CREATE TRIGGER test01 ON DATABASE FOR ALTER_PROCEDURE

  AS

  Any ideal ?

  Thanks a lot.

• onlo

  SSCertifiable

  Points: 5080

  More actions

  January 7, 2014 at 3:22 am

  #1677998

  Please ignore it.

  I fixed it.