var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I want to get the list of tables which an SQL query is using.It should be an automated solution
It could be through some query or parser written in jruby or R or any other language,any thrd party tool(freeware)or any scripts.
I've not heard of anything that will identify every table "hit" when all of the pieces of a query are run (i.e. stored procedures, user-defined functions, triggers, etc).
You might also look here:
SQL Server Query Execution Plan Analysis - SQL Server Performance
and see if this will help.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors