Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2001
    Posts
    16

    Unanswered: after upgrade sp is getting problem

    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

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    When you upgrade it is advised that you drop and recreate all your compiled objects (e.g. stored procedures, triggers, etc.).
    Thanks,

    Matt

  3. #3
    Join Date
    Feb 2002
    Location
    India
    Posts
    9
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •