In an attempt to lower the duplicate entry of records into my table I created constraint unique nonclustered on the email field. the problem is that my records might not have an email address so it will be null... with the current constraint i have... i cannot have multiple records with null email address... any suggestion on what can i do to modify that?
/****** Object: Index [IX__Email_tblContactInfo] Script Date: 12/22/2009 11:43:07 ******/
ALTER TABLE [dbo].[tblContactInfo] ADD CONSTRAINT [IX__Email_tblContactInfo] UNIQUE NONCLUSTERED
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]