|
|
Posted by xAvailx on 10/17/06 17:37
>> The problem is that I don't want to change the function, for fear that it is being called by one of the other SP's or triggers in the database (there are hundreds of them) <<
It is considered good practice to have your database objects scripted
and in source code control. If that is the case, then you can use any
text editor to search and manipulate the sps, triggers, udfs, etc...
If that is not the case (I would still recommend scripting), I found
this post with a util stored proc that you may find useful (don't know
if it works or not...)
http://groups.google.com/group/comp.databases.ms-sqlserver/browse_thread/thread/8a080b51fdc550b2/b83473d28f272d4%23b83473d28f272d4
HTH
marcsirois@gmail.com wrote:
> I am maintaining an application where most of the business rules are in
> Triggers, Stored Procedures and User Defined Functions. When a bug
> arises, it can get very tedious to debug. Today for example, I wanted
> to modify a function that was being called by a trigger. The problem
> is that I don't want to change the function, for fear that it is being
> called by one of the other SP's or triggers in the database (there are
> hundreds of them)
>
> Essentially, I need a tool that allows me to view where functions and
> sp's are being referenced from. At the very least, I'd like to perform
> a "full text search" in the database objects, so that let's say I have
> a function named "fn_doSomething", I can search the schema for this
> string and get all the places where it appears.
>
> As you can see, I'm in the dark here. I've never worked on a system
> where all business rules are at the database level. If you know of a
> tool that does what I describe above, or anything else that would
> facilitate my life, please let me know!
>
> Thanks for your help,
>
> Marc
Navigation:
[Reply to this message]
|