Doesn't a trigger fire after a successful insert? If so, then I don't pass a Pk value, i would get a null not allowed error and the insert trigger woudn't fire.

Am I wrong on this?

>Bob,
>
>Couldn't you turn this stored procedure into an insert trigger on the table?
>
>John
>
>
>>We have a stored procedure that gets the next available ID for a table, from a table that holds ID's... Is there any way to use this stored procedure as the default for the primary keys?
>>
>>Thanks,
>>BOb