Hi Sarosh,
You can create INSERT trigger and call your UDF from there.
>
>I have a table in SQL2005 with a non null int Column "ReferenceID" and I want it to have a Default Value every time I add a new row.
>
>I have a SP and a UDF which both return the required default value. (from another Counter Table)
>
>My questions is how do I get and set that value from the SP or UDF into that Column? I tried using the "Default Value or Binding Property" property for that column but it only allows build in functions or constants. I also wrote a UDF (User Defined Function) and tried using it in the "Default Value or Binding Property" but that doesn't work either. Also tried to define that Column as a "Computed Column Specification" Forumla with IsPersisted = Yes and this also does not let me use my UDF.
>
--sb--