Hi!

Thanks for the link.

Looks interesting.

Sarosh

>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