What exactly does "Entire Solution" mean in the Find dlg? 1

[jsteph]

Hi all,
In the SMS for sql-2005, I'm using the Find dialog to find text in stored procedures. I don't want to have to open every one of hundreds of procedures within a database or schema to find what I'm looking for. So I dutifully checked the "Entire Solution" box in the Find dialog and it appears to be meaningless--or at best it means the same as "only look in the current document".

So my main question is really: How do I do a global search for text (globally meaning either server-wide or database-wide, it would be nice to have an option)?

And the secondary question is: What does "Entire Solution" mean in this context?
--Jim

 

[Jamfool]

The find options within SSMS will search the active document, all open documents or if you have a solution then all documents in that solution.

by solution we basically mean a collection of script which have been grouped. ( there is basically a file with a list of the component scripts )

It does not search the server or database or database objects. unless you specifically have the text of these objects open.


ok...


So if you want to search for an object you can use several methods.

1. View, Object Explorer details (or hit f7)

This will show you a search dialog which will be anchored to which ever level you have highlighted in the object explorer. e.g at a single database level..it will search that database.

2. You can also do this via sql, of which there several sql views. some below:

SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%something%'

SELECT * FROM INFORMATION_SCHEMA.TABLE
WHERE TABLE_NAME LIKE '%something

if you want to search for the text within a sql object, you can use something like:

select sc.text, sc.id, so.name, so.type
from syscomments sc inner join sysobjects so
on sc.id = so.id
where text like '%something%'

 

[jsteph]

jamfool,
Excellent! the last statement was exactly what i needed, thanks!
--Jim