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