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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 documentation to my package and DB

Author  Topic 

inbs
Aged Yak Warrior

860 Posts

Posted - 2010-07-18 : 06:39:03
i want to create documentation to my packages,db and views,
stored prcedures.

is there any way to find column in all my packages in all my solutions?

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2010-07-19 : 19:30:51
There is a tool (free) from RedGate called SQL Search which will parse through the object definitions for the occurance of a string, such as column name. It's a useful tool but conspicuously absent are searches into Job Step definitions and SSIS Packages.

HTH

=======================================
A couple of months in the laboratory can save a couple of hours in the library. -Frank H. Westheimer, chemistry professor (1912-2007)
Go to Top of Page
   

- Advertisement -