I have several columns that I want to set to have unique values only in SQL 2000. I'm using MS SQL Server Management Studio Express 2005.
I have set the column ID as primary key. But I want to make sure that EMAIL and USERNAME are always unique so that I dont have to rely on doing "manually" checks via a script.
From what I understand I should set EMAIL and USERNAME as unique indexes. Is this correct? If so, how do I do that in Studio Express 2005. If not so, what should I do?