June 7th, 2004, 10:45 AM
|
|
Registered User
|
|
Join Date: Jun 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Strange trigger Behavior
I have a trigger on each table in a SQL Server 2K database which updates a datetime column (lastupdatedon) and a varchar field (enteredby) after update on each individual table. The problem is, when one table is updated at the same instant as another table (by different users), the same varchar data (SYSTEM_USER) is put in both tables, even though the users are different.
Here is an example of the trigger:
CREATE TRIGGER EventUpdate ON jrowley.Event
AFTER UPDATE AS
UPDATE jrowley.Event SET LastChangedOn = getdate(),EnteredBy = SYSTEM_USER WHERE EventID in (Select EventID from deleted)
Here is a little more info about the application. It is a stand alone application deployed to individual desktops and written in DataEase NetPlus ( basicly a wrapped c++ RAD tool). The connection to the DB is through the 'SQL server client network utility' with a tcp/ip connection.
Any suggestions are welcome.
Thanks,
Jerry
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
