Actually the OP's post is poorly worded.
SSN - unique column? Of course it has to be unique! SQL Server does not allow more than one column with the same column name!
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]