Posted by marcsirois on 10/13/06 12:01

You're right, Ed. For instance, if <function name> is referenced from
8 different places in a stored procedure, it will only return 1 result.

That's why I was asking about some sort of 3rd party tool that would
allow you to seasrch for a string, return all the instances where it's
found, and let you navigate across the results. Ideally, you'd click
on a stored procedue for example, and the tool would return all areas
where this stored procedure is called, and vice versa.

I'm sure something like this exists, it's just a matter of finding it.
Unfortunately, my google skill are failing me.

But for now, the "select from syscomments" solution will do.

Thanks,

Marc


Ed Murphy wrote:
> abc wrote:
>
> > SELECT *
> > FROM syscomments
> > WHERE TEXT LIKE '%<your function name>%'
>
> Doesn't this miss instances where <your function name> is split
> across two chunks of text?

• Next in forum: Re: Case Statement in Where Clause
• Prev in forum: Using trigger to notify an assembly of changes.
• Thread view: Re: Is there a way to view Stored Procedure, Trigger andFunction Usage in SQL Server?

[Reply to this message]