Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amjath78
Starting Member
2 Posts |
 Posted - 2007-03-12 : 12:15:03
|
| I want to know howmany tables were accessed in a database from time A to B. How do I get the list of tables accessed (excluding the 'SELECT's)? |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-03-12 : 12:44:58
|
| 1. use SQLProfiler to trace all SQL activity. must be in place and active before period being monitored.2. use triggers to log relevent (insert/delete/update) activity into a logging table. |
 |
|
|
amjath78
Starting Member
2 Posts |
Posted - 2007-03-12 : 13:56:37
|
| Thanks Andrew.. How do I add triggers?? any idea?? |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-03-13 : 06:52:15
|
| Come-on!!!....Any chance you could "Google 'trigger' + 'sql'" or look up Books-Online?or even search here for same...There's got to be a little bit of effort on your behalf....!! |
|
|
|
|
|
|
Tables Accessed