View Single Post
Old November 12th, 2004, 07:12 PM
Arsi Arsi is offline
Authorized User
Points: 457, Level: 7
Points: 457, Level: 7 Points: 457, Level: 7 Points: 457, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Aug 2004
Location: Burbank, CA, USA.
Posts: 95
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Arsi

Hi happygv!

Again, thank you for your help.

You're right i did not know about the deleted & inserted tables. I am very new to Sql server. I can only do very basic things. I changed my trigger per your example, but something keeps going wrong. The update is passed to the database via a Sqlcommand and connection in C#. It updates correctly when the trigger is not on the database, but once I put the trigger on the database, the first update does not even execute. I don't understand why it doesn't allow for the code to finish executing. It errors out at dbComm.ExecuteNonQuery(); this only occurs when the trigger is placed on the database. What do you think I should do?