I will test that and then probably use it.  Sounds like the best option.  I guess if I had done a little reading I probably would have found that.

Thanks.

Once again, sorry for the silly questions.  I think I've solved my problem well enough.  @@Identity didn't work because I do have a trigger running that archives the records.

Unfortunately, the...

Actually... sorry, I should have searched first... I may have just found my own problem.  I have a trigger on this table that archives the record on insert, update and...

Whoa.... I figured it out... and it produced a behaviour in SQL I've never seen before.  I'm posting this in case anyone else would like to be able to do...

Ok, I had read that stuff too.  Conceptually, it all makes sense.  However, I have not been able to find a definition for the DRIDefault property of a column and...