The target table 'Employee' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause.

• Swamy Magam

  Ten Centuries

  Points: 1096

  More actions

  July 3, 2008 at 8:16 am

  #188910

  Hi Friends

  I Have a table Like Employee contating columns (Id (identity),Name Varchar)

  for this table i am creating a trigger for insert ,update, delete.

  When i am inseting to employee query is

  insert into employee(Name) output inserted.Id Values('Scott'),

  it is throwing below error

  'The target table 'Employee' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause.'

  Please Help Me.

  Thanks in advance

  Regards

  swamy.

• GSquared

  SSC Guru

  Points: 260824

  More actions

  July 3, 2008 at 12:05 pm

  #838054

  The Output clause selects data. A trigger shouldn't do that. Output Into will store the data in a separate table, a temp table, or a table variable.

  What are you trying to do with the ID that you have in the Output clause?

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

• MannySingh

  SSChampion

  Points: 12465

  More actions

  July 3, 2008 at 12:06 pm

  #838055

  Try Creating a Table Variable and get the output on the Table Variable.

  OUTPUT inserted.Id into @tablevariable.

  Maninder
  www.dbanation.com