Make nSN an IDENTITY column.

>I have a table which contains fields called EmployeeID, nSN. While insert record, I need to get the max value of nSN of the particular employee in table, increase its value +1.
>
>I faced problem that, more than one record have same nSN value.
>How could I prevent this?
>
>Thank you