Hi all,


We upgrade the version 12.0 from 11.5.1 (NT).

before upgrade there is no problem with front end application as well as backend too. but after upgarde we are facing a problem. i.e whenever we need to run a particual process(this will all one sp) the system is getting hang. Before runing this process we are doing update statisctics.
after that this process is go through. This is after update statisctics also
we are unable to run that sp. Please help me out.

Siva

When you upgrade it is advised that you drop and recreate all your compiled objects (e.g. stored procedures, triggers, etc.).

Hi,

After the upgrade , U must run sp_recomplie for all the user objects(e.g Tables),no need to drop & recreate the procedure or triggers.If u have a downtime then it's better to run the Update Statistics

Yours

Prithivi Nagraj