Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pandara
Starting Member
1 Post |
 Posted - 2011-06-20 : 17:50:40
|
| What are steps that I have to take in order to gain access to SQL statements and stored procedures that are contained within a database? What I want to do is analyze the statements and figure out the fields and tables being used in the SQL statements and store that information within a separate database. For example: the field ‘gender’ in table ‘humans’ is used 15 times by 15 different SQL statements. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-20 : 21:59:37
|
| Also look at SYS.DM_DB_INDEX_USAGE_STATS. |
 |
|
|
|
|
|
How to analyze/access SQL statements in Database