> I need to upgrade several databases (1.5 & 2.0) to 2.1 in the near
> future. I
> was planning on doing the standard "backup with old version, upgrade,
> restore with new" method but realised that means the old udf's will be
> carried forward whereas I want to use the new built-in version.
>
> I'd rather not have to do each one manually, any suggestions for a
> scripted method
>

you mean in all your triggers and SPs?
If so, I would register 2 copies of the DB in your favourite admin tool
(source and target).
Do a search and replace on old UDF functions to change to new ones, or edit
manually as required until you make all the changes required.
Then do a DB compare (many tools for this) to create an update script.
Then test the Update script/backup/restore cycle on the target DB. And test
again and again to make sure before you deploy :-)
Alan