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 |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2003-03-12 : 10:36:11
|
| I've got a number (maybe 50) stored procedures which are stored in separate files and folders.Anyone have a good search mechanism to find all the procedures that contain specific text (e.g. a column name?)Sam |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-03-12 : 10:43:38
|
| The Windows Search facility lets you search specified folders and file types, and you can tell it to locate files containing certain text. It's on the Start menu. |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-03-12 : 11:13:50
|
| You want to find the create script, or they are already created? If they are already created, and you just want to know which ones contain certain text, you can query syscomments.-Chad |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-03-12 : 11:14:01
|
| I must've botched indexing or search service on this PC. It finds nothing in SQL files, no problem in DOC, XLS and other files.Sam |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-03-12 : 11:36:39
|
Hi Chad,I'm more interested in a simple text search. The procedures are created and lying around on disk. Sam - Were that query analyzer would do a text search among files.  |
|
|
|
|
|
|
Finding procedures that reference columns