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 |
|
moto1707
Starting Member
1 Post |
 Posted - 2011-12-08 : 19:13:40
|
| Hello,I have taken over a legacy SQL Server 2008 R2 system.I would like to track which tables are being accessed over a 45 day period as there is no doubt a bunch of unused tables in the database.Not all the tables are indexed so using sys.dm_db_index_usage_statsis not much use.Is there an audit option I can turn on for the database or soemthing else to track which tables are being accessed?Thankyou |
|
|
Bit Wrangler
Starting Member
9 Posts |
Posted - 2011-12-12 : 08:07:27
|
| SQL Server Auditing?[url]http://msdn.microsoft.com/en-us/library/dd392015.aspx[/url] |
 |
|
|
|
|
|
Determine which tables are being accessed