Hi,
I have more than 1100 tables in my databse. From existing application data will insert into Database tables. I need to track the tables module wise when data inserting/Updating into these tables.
One way is, I have to write the triggers for each table[1100 tables with auditing]. In my case this is not possible to write like that.
Is thesre any other solution to find the updated,inserted tables when data is changing from application without doing bulk changes.
Regards
Hanu
unfortunately SQL Server can not do this until unless we have our own mechanism.
Madhu
No comments:
Post a Comment