"ALL SERVER" option for DDL trigger

• nithiyanandam-447806

  Ten Centuries

  Points: 1197

  More actions

  July 5, 2010 at 3:15 am

  #224540

  Hi,

  Can anyone help me for this...

  I tried to create a DDL triger for "ALL SERVER" option.

  here is my code...

  Create Trigger Trigger_table_DDL

  on ALL SERVER

  for

  create_table, drop_table, alter_table

  as

  Insert into [dbo].[track_table]

  ( [datachange]) ---- this is XML datatype and not null column

  Values (eventdate())

  GO

  it returns the following error message....

  ****************

  Msg 1098, Level 15, State 1, Procedure Trigger_table_DDL, Line 12

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

  *********************

  Thanks in advance...

  Nithiyanandam.S

• Sean Elliott (UK)

  SSCommitted

  Points: 1626

  More actions

  July 5, 2010 at 5:56 am

  #1188746

  You might want a much better solution. See http://www.sqlservercentral.com/Forums/Topic947481-391-1.aspx

• nithiyanandam-447806

  Ten Centuries

  Points: 1197

  More actions

  July 6, 2010 at 5:54 am

  #1189032

  hi sean,

  Thanks for your reply. thanks lot