Posted by traceable1 on 04/26/07 15:41

That is PERFECT!! Thank you so much!


On Apr 26, 12:25 am, "Plamen Ratchev" <Pla...@SQLStudio.com> wrote:
> In SQL Server 2005 I have used the sys.dm_db_index_usage_stats dynamic
> management view to check for index usage. Essentially a new row is added for
> the index when it is used. The catch is that the info in
> sys.dm_db_index_usage_stats is reset when the SQL Server service is
> restarted.
>
> HTH,
>
> Plamen Ratchevhttp://www.SQLStudio.com

[Back to original message]