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

  • Thread starter Thread starter Joss
  • Start date Start date
J

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update a date field using a trigger. 7
remove a row without squaking about constraint violations 3
Change how a slide is triggered 0
Access 2003 ADP Write Conflicts with SQL server triggers 2
.adp update query using 2 tables 7
TableAdapter, INNER JOINs, stored procs, and problems with Update 4
returned row count when a trigger is invoked 6
how to pass parameters from forms to stored procedures 21

Back
Top