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.
Is thesre any other way to find the updated,inserted tables when data is changing from application.
Regards
Hanu
hi,
You may get more help posting it in
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=93&SiteID=1
SQL Server Database Engine forum
Although i maybe wrong
Good luck
Matt
No comments:
Post a Comment