Procedural code automatically executed in response to a database event.
1
vote
2answers
15 views
MySQL Federated tables and Triggers
This is the scenario.
Have two MySQL servers (S1, S2) on different machines, with a database on each (DB1, DB2).
I have a table (T2) on DB2 that needs to "fectch" rows from another table (T1) on ...
2
votes
1answer
46 views
What are the risks for logging across databases via a trigger?
I've searched for this online and had mixed or unclear responses, and after posting on superuser, was directed over here.
On SQL Server 2005, we currently log certain table changes via triggers using ...
2
votes
1answer
129 views
MySQL generic trigger to save identification data for later accessing of the changed row
I am pretty inexperienced with this.
I need a generic trigger, able to create and save in a fixed table some sort of identification data for a changed row from generic (any) table. The ...
0
votes
1answer
35 views
MySQL Replication and Triggers
I have stumbled upon an interesting MySQL Error message that I do not really know how to interpret.
The setup:
There are two tables A and B.
When data is written or updated in the table A, then a ...
0
votes
1answer
41 views
Disable trigger still fired
I've just run the following t-sql to disable a trigger (with a deploy script wrapper around osql):
disable trigger dbo.trExampleTableInsert ON dbo.ExampleTable
In SSMS I could see the trigger was ...
0
votes
1answer
139 views
Execution of a java program by a trigger
Can an update trigger execute a java program?
I have a table T1 with a column named Flag. Whenever Flag changes, I want to run a trigger that results in an execution of a java program.
2
votes
0answers
82 views
SQL Server and updating windows firewall rules
Any ideas how should I proceed if I would like to update the firewall rules (essentially add ip-s to existing firewall rule).
The step of exporting ip-s to text file and then using command line to ...
1
vote
0answers
26 views
Why Oracle Database trigger can became DISABLED
We have an application, using ddl database trigger on oracle database.
Trigger depends on package and several tables, package depends on user defined function.
It works on different customer sites ...
1
vote
0answers
194 views
Trouble with triggers and insert .. on duplicate key update
I have two tables with identical schemas. one is a "main" table that is pruned periodically and kept small. The other is a "reporting" table that is an archive of everything that ever was. For ...
1
vote
0answers
87 views
TSQL Trigger Incorrect Syntax
Im a SQL noob but here goes - I have a trigger in SQL which is giving me an incorrect syntax error E.G:
INSERT INTO aTable
(
tTypeId,
opId,
inserted.Id
)
SELECT
3,
0,
inserted.Id
...
0
votes
0answers
22 views
Fast afterUpdate cross-database trigger blocks insert
I'm trying to fix a timeout issue in an existing application.
There is a trigger on after_update that cascades a value from the update from master.Client to internal.Client and external.Client
The ...
0
votes
0answers
95 views
error in creating trigger in phpmyadmin
I have 4 tables:
event:
event_id(p.k) | uid | circle_id(f.k)
activity:
uid | performed_activity_id(f.k->event_id) | activity_type_id
follow:
follower_id | circle_id(f.k)
noiticication:
...
0
votes
0answers
66 views
mysql alternative to prepared statements in triggers
I'm trying to get some stored procedures to fire from a MySQL 5.1 trigger. When these were called without triggers, I used prepare and execute statements to build queries and other SQL calls. I have a ...
0
votes
0answers
36 views
Duplicate entry '0' for key 'UQ_CallsIDCC'
I have my own Server with Voice Switch and not really familiar with SQL.
Having problem with following:
02-25 12:05:32 MySQL error description : Duplicate entry '0' for key 'UQ_CallsIDCC'
02-25 ...
0
votes
0answers
107 views
FOR UPDATEor INSTEAD OF UPDATE Trigger?
I am working on my project at university - database in MS SQL Server for some sort of travel agency.
I would like to create a trigger to check if I can add another reservation for specific Holiday ...
0
votes
0answers
183 views
MS Access trigger
I got a trigger to update a table in SQL.
My actual need is in MS Access but I could not make it. So please help me to write the same trigger in MS Access.
Query is as follows:
Create trigger ...
0
votes
0answers
53 views
memc_delete called from a MySQL trigger loop fails randomly
I'm calling memc_delete from a MySQL trigger's code. The call is inside a loop. Logging the results, I see that memc_delete sometimes returns 1 (ok, memcached entry deleted) and sometimes returns 0 ...
