Hi Sarosh,

Not exactly an answer on your question, but check http://www.tek-tips.com/viewthread.cfm?qid=1126449

>Hi!
>
>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.
>
>What is the best way to solve my problem?
>
>Thanks
>
>Sarosh