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
Elliott Whitlow
SSC Guru
Points: 102402
More actions
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