So far I have only skimmed the book but I am puzzled why in chapter 15 it appears to advocate generating primary keys via a stored procedure as opposed to auto-increment.

I have a problem with this stored procedure in chapter 15 for primary key generation, it isnt working! I have run the actual example file to make sure it isnt an error of mine, and when i run it and add a new person the stored procedure does not return the next primary key value, instead the primary key feild on the form is just set to 0.
I have been using google a lot, i really need to get my head round generating a primary key and i cant do it.. I have made sure that networking is on, and that CLR is turned on using the surface area confiduration utility. Could someone please please help me with autopoulating the id feild in this form with the next integer value.