DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Trigger Problem

  1. #1
    Join Date
    Aug 2005
    Posts
    1

    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.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote Originally Posted by ashishshah
    Is it posible to use only one trigger for more than one table in database? if Yes Plz how ?
    No.

    Quote 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
  •  


Click Here to Expand Forum to Full Width