"Hans Kramer" <noms@xs4all.nl> wrote in message
newsan.2006.02.17.12.29.15.49500@xs4all.nl...
> On Fri, 17 Feb 2006 13:04:37 +0100, Rob Verschoor wrote:
>
> > I don't think you can implement that sort of check with 100% certainty
if
> yep, tough cookie!
>
> > you assume the syscomments text could be modified. In any case, the
> > query tree would not be unique: different stored procs could well have
> > the same query tree.
> Okay, if that's the case then it looks my effort is doomed!
> Unless you mean that a different stored procedure could be defined the
> same and thus produce the same query tree. I wouldn't care about that. I
> only care that the stored procedure I will call hasn't been "patched" with
> for instance an extra delete, insert or whatever statement!
>
> I will try to retrieve the "hidden" column from the CT lib calls and
> experiment a bit... it is Friday anyway!
>

Don't bother... you can't. When I said 'hidden' that was more to illustrate
the concept -- not suggesting you could 'find' it in anyway...

Rob V.