| Posted by Barry on 01/11/07 14:36 
In sqlserver 2000 I have a UDF which works fine but I want to make achange to it.  When I do an ALTER FUNCTION ... I get an error saying
 that I can't alter the function because it is referenced by an object.
 Is there any way around this? I reference the UDF in over 100 tables,
 do I have to go to each table, remove the all references alter the
 function then edit each 100 tables again?  How clumsy can it be?
 
 Barry
  Navigation: [Reply to this message] |