View Single Post
Old 22-Oct-2007, 12:46 AM   #2 (permalink)
Anilrgowda
Administrator
 
Anilrgowda's Avatar

Posts: 18,715
Join Date: Jan 2006
Rep Power: 10 Anilrgowda is on a distinguished road

IM:
Default Re: Foreign Key T-SQL Syntax

First error means there are duplicate records in your os_systems column of apps table. Naturally, you can't put a unique constraint on it.

Second error is because of the absence of the unique constraint that we tried to create in first statement (and failed).

If you can't remove duplicate values from os_systems column of apps table, you can't do this activity.


------------------


Anilrgowda is offline   Reply With Quote