Cannot get trigger to fire from third party software

• danderson 57106

  Valued Member

  Points: 72

  More actions

  June 7, 2010 at 1:59 pm

  #147484

  I have a trigger created on one table which works when I update the table directly from SQL Server. But when I update the table from my ERP software it does not run. I traced the profiler and ran the same exact update directly from SQL and it works but when its being executed from the ERP software it does not fire the trigger. Thoughts?

  This is what the profiler says:

  RPC:Completedexec sp_executesql N'UPDATE JOBS SET STATUS_FLAG=@P1,SCHEDULE_RUN_NUMBER=@P2 WHERE GEM_DBKEY=@P3',N'@P1 varchar(1),@P2 varchar(6),@P3 int','H',' ',14671CDC Software DML Runtimeman_sand0515352756992010-06-07 13:50:18.5702010-06-07 13:50:18.6030X00000000060000001A00730070005F006500780065006300750074006500730071006C00AE00000082000A0063206E0074006500780074009600000055005000440041005400450020004A004F

  exec sp_executesql N'UPDATE JOBS SET STATUS_FLAG=@P1,SCHEDULE_RUN_NUMBER=@P2 WHERE GEM_DBKEY=@P3',N'@P1 varchar(1),@P2 varchar(6),@P3 int','H',' ',14671

  Is there some permission that I am missing?

• Leo.Miller

  SSChampion

  Points: 13051

  More actions

  June 7, 2010 at 7:35 pm

  #1177283

  Quite possibly a permission error. Have you set the trace to capture errors?

  Leo

  Leo
  Nothing in life is ever so complicated that with a little work it can't be made more complicated.