<div>
OK-<br />
<br />
I guess in 2000, that is the only option, right?<br />
<br />
what about in 2005 &amp;&nbsp;2008?
</div>


OK-

I guess in 2000, that is the only option, right?

what about in 2005 & 2008?

<div>
good point - INFORMATION_SCHEMA.ROUTINE<wbr />S also will work on all versions, right?
</div>


good point - INFORMATION_SCHEMA.ROUTINES also will work on all versions, right?

<div>
correct, INFORMATION_SCHEMA.ROUTINE<wbr />S for all versions
</div>


correct, INFORMATION_SCHEMA.ROUTINES for all versions

<div>
&quot;Returns the first 4000 characters of the definition text of the function or stored procedure if the function or stored procedure is not encrypted. Otherwise, returns NULL.&quot;<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/ms188757%28SQL.90%29.aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/ms188757%28SQL.90%29.aspx</a><br />
<br />
Where do you get the Views and Triggers code from? <br />
As far as I'm aware they are ALL in sys.syscomments.text column<br />
<br />

</div>


"Returns the first 4000 characters of the definition text of the function or stored procedure if the function or stored procedure is not encrypted. Otherwise, returns NULL."

http://msdn.microsoft.com/en-us/library/ms188757%28SQL.90%29.aspx [http://msdn.microsoft.com/en-us/library/ms188757%28SQL.90%29.aspx]

Where do you get the Views and Triggers code from?
As far as I'm aware they are ALL in sys.syscomments.text column



<div>
<br />
@icohan<br />
What are you talking about?<br />
<br />
This question is about UDFs and Stored Procedures
</div>



@icohan
What are you talking about?

This question is about UDFs and Stored Procedures

<div>
Right - my bad...overlooked that and thought is ALL sql code objects.<br />
Please disregard my answer.
</div>


Right - my bad...overlooked that and thought is ALL sql code objects.
Please disregard my answer.

<div>
<div class="content wysiwyg-content">
what is the best system table in 2000 and 2005+ to search for specific text in a code (UDF or proc) etc<br />
<br />
thanks
</div>
</div>


what is the best system table in 2000 and 2005+ to search for specific text in a code (UDF or proc) etc

thanks

best system table to search code

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.