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 |
|
govula
Starting Member
2 Posts |
 Posted - 2008-02-22 : 15:03:14
|
| Hi all, I am a graduate assistant in Central Michigan University. Currently, My work is to create a table or a catalog that explains all the details of a table and the fields with in the table. We are the looking for details like, stored procedures or Views or other tables or Reports that are using the particular field or table. How can i capture those details and make it as an automated process, which updates when ever there is an add on in use or something else.Please help me with this as soon as possible.Thanks,Swaroop Govula |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-02-22 : 16:24:17
|
| SQL Server 2005 has DDL triggers. Check it out in SQL Server Books Online for details.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-02-22 : 16:48:06
|
sqlspec may be able to help you with this, see the link in my sig. it will show you dependency graphs for each object. also you can search the output for any keyword (like a column name) to see where it is referenced.
elsasoft.org |
|
|
|
govula
Starting Member
2 Posts |
Posted - 2008-02-22 : 17:32:42
|
| Thank you for every one.Swaroop Govula |
|
|
|
|
|
|
About Database catalogs