Re: Mysterious corruption of procedures?
From: Reginald W. Bailey <rwbailey_at_usa.net>
Date: 1996/11/18
Message-ID: <01bbd582$df1d8860$4b4e8486_at_rbailey>#1/1
Date: 1996/11/18
Message-ID: <01bbd582$df1d8860$4b4e8486_at_rbailey>#1/1
If the stored procedures access any other database objects such as tables, views, stored procedures , etc. , and those objects get changed, then the stored procedure may need to be recompiled. If a table is destroyed and recreated, then the stored procedure would need to be recompiled. Also, if the database was upgraded and some system stored procedures were replaced or updated, if your stored procedures were dependent upon them, then they would need to be recompiled.
R.W. Bailey Received on Mon Nov 18 1996 - 00:00:00 CET