<div>
CREATE PROCEDURE FindObjects(@KeyWord as varchar(100))<br />
AS<br />
SELECT<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM sysobjects O<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;INNER JOIN syscomments C on O.ID = C.ID<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE C.text like '%' + @KeyWord + '%'<br />
<br />
GO<br />
<br />
FindObjects 'YourStringToFind'<br />
<br />
-----------------------<br />
<br />
This method has the flaw that any token which is split by an 8000-byte boundary will not be found. Do you want a version that does not have this limitation?
</div>


CREATE PROCEDURE FindObjects(@KeyWord as varchar(100))
AS
SELECT
      *
      FROM sysobjects O
            INNER JOIN syscomments C on O.ID = C.ID
      WHERE C.text like '%' + @KeyWord + '%'

GO

FindObjects 'YourStringToFind'

-----------------------

This method has the flaw that any token which is split by an 8000-byte boundary will not be found. Do you want a version that does not have this limitation?

<div>
I'm still here, but I guess the Asker is awol
</div>


I'm still here, but I guess the Asker is awol

<div>
<div class="content wysiwyg-content">
I used to have a script that I ran in Query Analyzer called Where_Am_I. &nbsp;It would allow me to search a database for any reference to string that I passed as a parameter. &nbsp;i.e. Where_Am_I &nbsp;'UserName' &nbsp;might return a list of all the tables that contain a field called UserName and all stored procedures that have a reference to this field.<br />
<br />
I was hoping someone might have a sql script like that they can provide.<br />
<br />
Thanks.
</div>
</div>


I used to have a script that I ran in Query Analyzer called Where_Am_I.  It would allow me to search a database for any reference to string that I passed as a parameter.  i.e. Where_Am_I  'UserName'  might return a list of all the tables that contain a field called UserName and all stored procedures that have a reference to this field.

I was hoping someone might have a sql script like that they can provide.

Thanks.

Where_Am_I  Script

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.