I have an application accessing various tables in a SQL Server database.
I want to have a list of all those table which the application has accessed for select , Insert and update operation.
Currently i am using SQL Profiler to trap all the queries and searching for table names in TextData column.
Is there any way to get the list of tables which the application is accessing.
You can track that information yourself quite easily, or use a third party
application.
http://www.aspfaq.com/2448
http://www.aspfaq.com/2496
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Ishwar Jindal" <anonymous@.discussions.microsoft.com> wrote in message
news:1B5549AE-58A5-4A3E-9422-EDE6FF7A07CD@.microsoft.com...
> I have an application accessing various tables in a SQL Server database.
> I want to have a list of all those table which the application has
accessed for select , Insert and update operation.
> Currently i am using SQL Profiler to trap all the queries and searching
for table names in TextData column.
> Is there any way to get the list of tables which the application is
accessing.
No comments:
Post a Comment