I have a doubt. Guess I am changing the structure of the table T1 and more than one stored procedures are using this table.
Then do I need to recompile all the procedures using this table? If yes,then is there any shortcut or method using which we need not to compile each stored procedure separately.
I have a doubt. Guess I am changing the structure of the table T1 and more than one stored procedures are using this table.
Then do I need to recompile all the procedures using this table? If yes,then is there any shortcut or method using which we need not to compile each stored procedure separately. [/quote]
/dry.gif" style="vertical-align:middle" emoid="<_<" border="0" alt="dry.gif" /> not sure what you mean can you please make it more clear ?