Simple logging of table access In SQL Server 2008, is there some simple logging of how often a particular table is selected (in an hour, a day, a week, etc.)? I have a large table that is accessed by dozens of applications and scores of web pages. The data provider is threatening to make major changes to what is available and I need to start working on a demonstration of how much the data is accessed.
Assuming that there is an index on the table in question, you could try querying sys.dm_db_index_usage_stats.  It's a view so you will need to specify the database and object_ID of the table you are interested in.  You can query at intervals and store the results to get delta over time.  Look at the MSDN page https://msdn.microsoft.com/en-us/library/ms188755(v=sql.100).aspx for how to interpret the information.