JKSQL (6/11/2009)
I need the check on there. I have seen constraints that use udfs but I think that would be a bad idea...correct? So there is no way to do a unique constraint with those three column when isfilter = 0?
OK, Let me try again: You can NOT put a check constraint on an index. They must go on columns in the table definition.
Use the ALTER TABLE...ALTER COLUMN.. command to do this.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]