after upgrade sp is getting problem [Archive]

View Full Version : after upgrade sp is getting problem

siva

12-28-01, 00:45

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

MattR

12-28-01, 10:48

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

prithvi

02-23-02, 01:29

Originally posted by MattR
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