Martin Agren wrote: << ... Data output from my stored proc isnt reflecting the changes I have made. I make changes in DDL, check the "new" dataset (Flamerobin or my client app) and am not getting the desired results as data is unchanged. I make another change, still no effect. Then, when disconnectiong and restarting my client side apps all the changes suddenly appear. >>
Will your stored procedure need re-compiling before changes will show up in the results? I don't think the SP is recompiled until the database is closed and reopened - it could be difficult to recompile for you and keeping the old one for other users. OTOH - I could be mistaken. -- Aage J.
