Results 1 to 2 of 2

Thread: recompile proc

  1. #1
    Join Date
    Nov 2001

    Unanswered: recompile proc

    I added a index on a column. Do I need to recompile
    all the stored procedures which are accessing that column ?

    Is recompiling necessary for a procedure to use a newly added index ?


  2. #2
    Join Date
    Feb 2002
    Houston, TX
    Basicaly, yes. You imght want to use sp_recompile '<your table name>' as it will force all stored procedures and triggers associated with your table to be recompiled the next time they are run.
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

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