Subject | Edited Stored Procedure not taking place. |
---|---|
Author | C Fraser |
Post date | 2002-11-06T21:09:18Z |
Hi all,
I have just edited a stored procedure (about 10 minutes ago) and it
clearly is not being used yet.
I can disconnect from the db, go back into it and verify that the stored
procedure code has been updated, but the actions being performed by
other applications when executing the stored procedure clearly show that
old version of the stored procedure is being executed.
First question is, is this normal? Something to-do with transactions
perhaps?
And the next question is how do I get my new stored procedure to be
used?
Any info appreciated.
Regards
C Fraser
######################################################################
Attention:
The information in this email and in any attachments is confidential.
If you are not the intended recipient then please do not distribute,
copy or use this information. Please notify us immediately by return
email and then delete the message from your computer.
Any views or opinions presented are solely those of the author.
######################################################################
I have just edited a stored procedure (about 10 minutes ago) and it
clearly is not being used yet.
I can disconnect from the db, go back into it and verify that the stored
procedure code has been updated, but the actions being performed by
other applications when executing the stored procedure clearly show that
old version of the stored procedure is being executed.
First question is, is this normal? Something to-do with transactions
perhaps?
And the next question is how do I get my new stored procedure to be
used?
Any info appreciated.
Regards
C Fraser
######################################################################
Attention:
The information in this email and in any attachments is confidential.
If you are not the intended recipient then please do not distribute,
copy or use this information. Please notify us immediately by return
email and then delete the message from your computer.
Any views or opinions presented are solely those of the author.
######################################################################