Re: Help: How can I find the error in a Procedure programtically

From: Pete's <empete2000_at_yahoo.com>
Date: 2 Jul 2003 12:21:00 -0700
Message-ID: <6724a51f.0307021121.4b4cd75f@posting.google.com>

What about auditing? Or better yet, check to see what current invalid objects are, save a copy of the procedure, drop it, then check for all invalids again and determine the delta between the two lists.

HTH,
Pete's

The views I may have expressed here are solely my own and not that of my employer.

"charlie cs" <cs3526(no spam)@yahoo.com> wrote in message news:<A3yMa.9186$tw3.7756_at_nwrdny02.gnilink.net>...
> We have a procdure. Every night it will become invalid, but it will be
> recompiled automatically by our scripts. There is no bad influence on our
> production, so this problem was unattended for a long time.
>
> I am interested in writing a scripts, which will record why the procedure is
> invalid.
>
> Could some one tell me which dynamic view I should look to get the error
> message if a procedure becomes invalid?
>
> Your help is highly appreciated.
Received on Wed Jul 02 2003 - 14:21:00 CDT