Accepted answer

i assume you're creating it using the membership? if so, simply add a uniqueidentifier column inside your profiles table, set as primary key and you're good to go. sql won't allow you to add more than 1 record for that id.

this article provides exactly what you need

Related Query