why can stored proc update multiple rows but trigger can't?

[Joss]

In a ADP (MSSQL7). I have been trying to create a trigger that would update
multiple rows on table 2 when table has a row updated. It doesn't wok - I
get the 'Key column information is insufficient or incorrect. Too many rows
affected by update' error. I tried for hours to get around it but no joy.
Then, I created a stored procedure to do the job and it works fine. The code
is the same, but no error and everything gets updated.

What's going on????

From this, I gues I can maybe call the stored proc from the trigger, but is
that the correct way?

Jo

 

[Larry Linson]

Regardless of the user interface you are using (ADP), questions about
Microsoft SQL Server stand a far better chance of getting useful responses
if asked in a newsgroup devoted to Microsoft SQL Server. Triggers and Stored
Procedures are SQL Server features.

Larry Linson
Microsoft Access MVP