An alternative to using triggers on a SQL Server
I am using triggers to update two similar tables on a SQL Server. Is there any other method to do this?
Software/Hardware used:
Software/Hardware used:
ASKED:
January 21, 2009 5:59 PM
UPDATED:
January 22, 2009 1:54 AM
RELATED QUESTIONS
Answer Wiki:
You can write a stored procedure to update the tables then call the stored procedure instead of updating the table directly.
Short of that, no if you need to capture all data changes that are made to a table a trigger is the correct method.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
