November 20, 2006 at 8:44 am
Is there a way to find out which tables are being written to? One of my database is basically used for record management and most of the tables are static as users dont write to it. However some tables are updated. How do I find out which tables are being written to and which ones are static. and those which are being written to what exactly is the nature of change? or what DML is occuring there?
Thanks
Shahab
November 20, 2006 at 8:53 am
You could find that out using profiler... or by auditing all the tables. Search this site for "auditing tables" and you'll find plenty of information.
November 20, 2006 at 9:29 am
If you use SQL Server Profiler, do not forget to use filter. Otherwise, you may have troubles in performance.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply