-
Trigger Problem
Is it posible to use only one trigger for more then one table in database? if Yes Plz how ? or other Solutions ?
Purpose : Maintain history for all tables Add,Update,Delete tranzaction count only not information
Last edited by ashishshah; 08-22-2005 at 03:47 AM.
-
Originally Posted by ashishshah
Is it posible to use only one trigger for more than one table in database? if Yes Plz how ?
No.
Originally Posted by ashishshah
or other Solutions? Purpose : Maintain history for all tables Add,Update,Delete tranzaction count only not information
Write a trigger for every table that calls a procedure and passes the table name, new, old and changed data, as well as the operation type. That procedure will log the data.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|