http://blogs.msdn.com/euanga/archive/2008/05/28/sql-2008-how-do-i-tell-if-a-specific-table-is-still-being-used-in-an-app.aspxEver had to take over the code for a system you did not define? Ever found the documentation for such an app, to be ahemmm lacking? &#160; Its&#160; a fairly common ask from new app developers/ DBAs to find out if certain code is still being used foren-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/euanga/archive/2008/05/28/sql-2008-how-do-i-tell-if-a-specific-table-is-still-being-used-in-an-app.aspx#8586178Mon, 09 Jun 2008 18:37:14 GMT91d46819-8472-40ad-a661-2c78acb4018c:8586178Alan Barber<p>is this sql 2008 specific or will it work in 2005?</p> <p>Anyhoo, my major question is why doesn't the server do any built in tracking for tables like indexes? &nbsp;it's a common enough request you'd think it'd be worth adding support for that?</p>http://blogs.msdn.com/euanga/archive/2008/05/28/sql-2008-how-do-i-tell-if-a-specific-table-is-still-being-used-in-an-app.aspx#8587397Mon, 09 Jun 2008 23:50:53 GMT91d46819-8472-40ad-a661-2c78acb4018c:8587397euanga<p>Its SQL 2008 specific as the audit objects don't exist in 2005. In that case you would have to use trace.</p> <p>Adding it formally to the product is something that has been discussed but did not make it into 2008, we'll see if it makes a future version.</p> <p>Enter it on <a rel="nofollow" target="_new" href="http://connect.microsoft.com">http://connect.microsoft.com</a> and get others to vote to increase the chance</p>