T-SQL

Re: Search a custom text inside store procedures

xmldeveloper — Mon, 31 Aug 2009 14:03:11 GMT

Pentru a completa raspunsul initial:
In SQL Server 2000 - tool-ul Query Analyzer avea functionalitatea Object Search care facea exact ce va doriti.

In SQL Server 2005 din pacate odata cu Query Analyzer a disparut si Object Search (https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124498) insa puteti folosi ca model scriptul de mentionat anterior.

Re: Search a custom text inside store procedures

urechemm — Mon, 31 Aug 2009 13:50:20 GMT

E ok
Mutam mult se sfat.

Si scuze pt mesajul in limba engleza :P
Mihai

Re: Search a custom text inside store procedures

xmldeveloper — Mon, 31 Aug 2009 13:41:50 GMT

Puteti folosi ca model urmatorul script:

USE AdventureWorks;
GO
SELECT
[name],
OBJECT_DEFINITION(object_id) [procedure_text]
FROM sys.procedures
WHERE patindex(N'%@StartProductID%',OBJECT_DEFINITION(object_id)) > 0

Search a custom text inside store procedures

urechemm — Mon, 31 Aug 2009 13:38:45 GMT

Hello friends,

Can you tell me which is the script for searching a predifined text inside INFORMATION SCHEMA stored procedures ?

Thank you

Mihai