title: How to make "No Duplicates" column in SQL Server 2008?
body: <p>I have a simple table in my SQL Server database. This table contains two columns: <code>ID int, Name nvarchar(50)</code>. The <code>ID</code> column is the primary key for my table.</p>
  
  <p>I want the "<code>Name</code>" column to be "<code>(No Duplicates)</code>", like in Microsoft Access, But this column isn't the primary column. How could I do this?</p>