Question regarding Object querying

Platform - SQL Svr 2000 SP3a
I have a couple of questions regarding stored procs
1. Is there a way to query on keyword text withiin stored proceduers?
for example, if I wanted to find all stored proc's that contain 'AND
where col_name <> 3' in the statement(s), can I do that? Does Full-text
support only include Table objects?
2.) Do objects (specifically stored procedures) have a modified date
property that can be queried on? If so, how is this done?
Thanks,
-Troy> 1. Is there a way to query on keyword text withiin stored proceduers?
> for example, if I wanted to find all stored proc's that contain 'A
ND
> where col_name <> 3' in the statement(s), can I do that? Does Full-text
> support only include Table objects?
How do I find a stored procedure containing <text>?
http://www.aspfaq.com/show.asp?id=2037

> 2.) Do objects (specifically stored procedures) have a modified date
> property that can be queried on? If so, how is this done?
No. SQL Server does not save this information.
AMB
"Troy Jerkins" wrote:

> Platform - SQL Svr 2000 SP3a
> I have a couple of questions regarding stored procs
> 1. Is there a way to query on keyword text withiin stored proceduers?
> for example, if I wanted to find all stored proc's that contain 'A
ND
> where col_name <> 3' in the statement(s), can I do that? Does Full-text
> support only include Table objects?
> 2.) Do objects (specifically stored procedures) have a modified date
> property that can be queried on? If so, how is this done?
>
> Thanks,
> -Troy
>
>|||Thanks for the link. This very good.
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:D9E8C74E-19CA-4549-905B-F1364E59E726@.microsoft.com...
> How do I find a stored procedure containing <text>?
> http://www.aspfaq.com/show.asp?id=2037
>
> No. SQL Server does not save this information.
>
> AMB
> "Troy Jerkins" wrote:
>