"miriam healy" <miriam.healy@akqa.com> wrote in message
news:0e8901c52f13$d89d51c0$a501280a@phx.gbl...
> Out of interest, I have had the following happen and
> wondered if anyone had an explanation for the strange
> result:
>
> I executed an 'Alter Proc' against one of the FireRule
> stored procedures in a SNS database. This stored
> procedure was an event rule.
>
> After executing the 'Alter Proc' in SQL Analyser and
> recieving a 'Command completed successfully' I ran
> sp_helptext giving it the store procedure name and, as
> expected, the result was the changed stored procedure.
>
> However when, minutes later, I opened up the stored
> procedure directly in SQL Enterprise it was the old
> version of the procedure and not the new.
>
> Has anyone else had this? Is there an explanation why it
> happened?
>
> Love if any light could be thrown on the matter.
>
> Thakns, Miriam

Shyam Pather [MSFT] wrote:
> Miriam,
> I don't know why you're seeing the old version of the proc in Enterprise
> Manager, but I want to point out that you should not be altering database
> objects created by NS directly. If you do so, your application will likely
> end up in an unusable (and unrecoverable) state. If you want to make changes
> to an existing application, edit your ADF/config file and run nscontrol
> update.
>
> Thanks
> -shyam