Viewing 2 posts - 1 through 2 (of 2 total)
Try This:
Select <columns to check>
From <table name>
Group By <columns to check>
Having count(*) > 1
Eric
May 1, 2003 at 12:26 pm
#455934
According to Inside SQL Server 2000 by Kalen Delaney (p 410): "In terms of storage and maintenance of indexes, there is no difference between unique indexes created using the Create...
April 8, 2003 at 10:18 am
#453465