Suppose there is an stored proc. called SP1, and there is another one called SP2, and from SP1 you want to modify the functionality of SP2, for example before SP2 inserted 100 registers in a table, now you want to update instead of insert, or print the message "Hello world" instead of "Hello man!" or whatever,i.e. change the SP2 text and the next time i run this SP2 it executes the changes i make from SP1, how can i do this.
Hi thanX mkalsi you're suggestions help me but not at all, the text i want to modify is the static text code of SP2, for example i wanna search in the text code of SP2 (and also in others) if the word "HELLO" exists, if it does, then i wanna change it for another word directly in the syscomments system table and the next time i execute this SP then it compiles before the execution.