Track Object usage

[DrSql]

I am trying to track how often few tables are being used in a database and would like to track the login name and host name for that process. I know how to track this down using Profiler but in our prod environment we can't use it due to app timeouts. The environment is SQL 2005. Any help is greatly appreciated.
Thanks
Varghese


Dr.Sql
Good Luck.

 

[mrdenny]

SQL Profiler would be the correct tool to use.

You can setup a trace using T/SQL to export to a file, then import that file into a table and query it.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[DrSql]

Thank you for the response...
I will stop by and introduce myself at PASS: Storage for the DBA session.


Dr.Sql
Good Luck.