At 05:53 AM 7/02/2006, Lucas Franzen wrote:

>Jason Dodson schrieb:
> > I do have a backup of this database, if ultimately needed.
>
>which won't work since recreating a databae out of it will recreate the
>procedure which will make it work again - as you experienced with drop
>and create...

This isn't correct, actually, Lucas. SP's don't get recreated on a
restore. It's the BLR that is backed up (as a blob) and restored (as
a blob). You can back up a database that has had the PSQL sources removed.

>Do you still have the original database?
>Did you compare the BLR?
>Do you have a backup / restore of the databse from time to time?
>
>Are you sure that noone had/took access to the metadata?

I'd be interested in the possibility that the SP was originally
created in Dialect 1 and contained an operation that returns
different results in D1 and D3 and that, at some point, the DB has
been restored as D3.

./heLen