View tables opened in SQL 2005

Is there a way to view the opened tables under SQL 2005 when a user access a ERP application ? Hence, I could find out the right tables to build the reports.
AXISHKAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>For "sql-starting", is the the Events  TSQL --> SQL:StmtStarting and ignore the other events ?

yes

>For filter "user/database",  do you mean "Column Filters.." Button --> LoginName ?

yes
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you could run a SQL profiler trace, and there all the sql run against the database.
that's the way to go, you just have to set up to get all the sql:starting, and filter eventually by the user/database ...
0
 
AXISHKAuthor Commented:
For "sql-starting", is the the Events  TSQL --> SQL:StmtStarting and ignore the other events ?

For filter "user/database",  do you mean "Column Filters.." Button --> LoginName ?

I'm using SQL 2005.

Many thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.