>Hello All, I need to make a change to a UDF in SQL 2000 but receive an error message saying the object is being referenced by (mytablenamegoeshere), is there any way to override this constraint ? the UDF in question is referenced by a lot of objects and as I plan to do this change with the db offline there's not really a problem. I really don't want to have to remove all references to it

You have to otherwise you cannot modify UDF in question. See http://www.thescripts.com/forum/thread587038.html