i have a few tables in SQL Server2008 that have been in use for a while, i am trying to create indexing on a serial number field to avoid duplicates, i know in access i can change the table field to index no duplicates, in the server do i use the indexes and keys option by right clicking the field and then changing the unique to yes?? will this do what i need or am i totally off base here. thanks
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.