Michel,

In the table designer, if you look at the column properties, you'll see an item called 'Identity specification', and underneath that, you'll see an item called Is Identity. Set that to true.....

Also, immediately after an insert, if you want to know the value of the new identity column, you can say....

SELECT SCOPE_IDENTITY()

hope that helps...
Kevin