Trigger Not Executed even if record is inserted or Updated

Question

Trigger Not Executed even if record is inserted or Updated

Yogesh Khaire

SSC-Addicted

Points: 402
More actions
August 10, 2008 at 5:14 am

#99211

I am using WinCC as Front End and SQL Server 2000 as Backend. WinCC is Standard SCADA Application for Siemens Sytems. when Data Insert into Table from WinCC then Trigger will not executed.
But i am executing query from query analyser then Trigger works Fine.
why should this happens.
Please Help.............

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004372 More actions · Answer 1

It can't happen unless the trigger has code in it telling it to ignore the inserts from WinCC. Recommend you post the trigger code.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Check that the front end is inserting into the database you think it is. It's an easy mistake to make.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Yogesh Khaire SSC-Addicted Points: 402 More actions · Answer 3

I have written the Following Trigger on MsArcLong.

and there is no error in it.

because it is executed when data inserted through Query analyser.

Create Trigger Test on MSArcLong

For Insert,Update

As

Insert into MSArcLong1 Select Top 1 * from MsArcLong Order by counter Desc

Yogesh Khaire SSC-Addicted Points: 402 More actions · Answer 4

Yogesh Khaire

SSC-Addicted

Points: 402

August 10, 2008 at 9:31 pm

#855851

WinCC can Inserted data in the Table.

Jeff Moden SSC Guru Points: 1004372 More actions · Answer 5

yogesh.khaire (8/10/2008)
I have written the Following Trigger on MsArcLong.
and there is no error in it.
because it is executed when data inserted through Query analyser.
Create Trigger Test on MSArcLong
For Insert,Update
As
Insert into MSArcLong1 Select Top 1 * from MsArcLong Order by counter Desc

Like Gail said, you need to check your app for which database is being used because that trigger will work no matter what inserts data into the MSArcLong tablel.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Yogesh Khaire SSC-Addicted Points: 402 More actions · Answer 6

WinCC is a Standard Application which was Developed by Siemens.

we don't have Source code for that

Jeff Moden SSC Guru Points: 1004372 More actions · Answer 7

Ummm.... ok... how do you know it's supposed to insert into MSArcLong in the database you have setup?

The only other thing I can think of is that the app has code to disable any and all triggers, in which case, you're toast. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Yogesh Khaire SSC-Addicted Points: 402 More actions · Answer 8

Is there any way other than Trigger. ?

But i want fast Updation. when ever Data Inserted or updated in the Table i want to be insert that Data into another Table which was created.

Jeff Moden SSC Guru Points: 1004372 More actions · Answer 9

yogesh.khaire (8/10/2008)
Is there any way other than Trigger. ?
But i want fast Updation. when ever Data Inserted or updated in the Table i want to be insert that Data into another Table which was created.

Sure... if you make a change to and recompile the source code. Other than that, trigger is the only way to go. You just need to verify that the app is writing to the database and table you think it is because a trigger on the table will work just fine... and I don't believe that most 3rd party programmers are insidious enough to disable triggers on their tables.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

sgmunson SSC Guru Points: 110640 More actions · Answer 10

Jeff,

He appears to just want a copy of the insert, so would replication meet his need, or would that cause problems on speed of "Updation" ?

Steve

(aka smunson)

:):):)

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

RBarryYoung SSC Guru Points: 143329 More actions · Answer 11

What does profiler say about the Insert code?

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Jeff Moden SSC Guru Points: 1004372 More actions · Answer 12

smunson (8/11/2008)
Jeff,
He appears to just want a copy of the insert, so would replication meet his need, or would that cause problems on speed of "Updation" ?
Steve
(aka smunson)
:):):)

I think replication would be adding rust to the bucket. 😀 If the trigger isn't working, then I believe he's looking at the wrong table. If the trigger isn't working, then chances are you won't be able to get replication working either.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)