Home Forums Older Versions of SQL (v6.5, v6.0, v4.2) Older Versions of SQL (v6.5, v6.0, v4.2) Problem with ALTER PROCEDURE using SQL 6.5 RE: Problem with ALTER PROCEDURE using SQL 6.5

  • August 12, 2009 at 11:06 pm

    #1038458

    I have had this happen as well..

    Do a drop, call an exec of the proc, then recreate it.

    The call forces the engine to forget about anything it has cached for it.

    CEWII