You cannot set the default to be the return value of a stored procedure. In fact, the convention is that the return value of the stored procedure should reflect the status of the stored procedure's execution.
A User Defined Function might work, although I've never tried it.
Is there any reason that you're not using IDENTITY values for your PKs?
-Mike
>Hi,
>
>In SQL Server, is it possible to define the default of a field to be the return value of a stored procedure? For example how can I say that the default value of field CustomerPK is SP_MyNewId(
).
>
>TIA,
>
>Alex