SpeedBWild
Programmer
I am getting ready to upgrade to Great Plains 7.5, one of the pre-upgrade instructions is to recompile stored procedures to adapt stored procedures to tables with significant increases or decreases in data. What does this mean?
I wrote a script that select name from the sysobjects table where type ='p' and then I loop thought the list and run the exec sp_recompile tablename. When I ran the script it said the tablename was successfully marked for recompilation. Is this all that I need to do?
I wrote a script that select name from the sysobjects table where type ='p' and then I loop thought the list and run the exec sp_recompile tablename. When I ran the script it said the tablename was successfully marked for recompilation. Is this all that I need to do?