I have an SQL server 200 table with 4 columns, the first 3 of which are primary key. The table is case sensitive so putting 'A,B,Test,1' in one row and 'A,B,TEST,1' in another is fine as far as sql is concerned. When I create a dataset in visual studio and select the records I get an error saying that the constraints have failed. Using the 'Preview data' wizard shows that it regards the rows above as duplicates. I have specified that the dataset is case-sensitive but cannot get it to work.
Any suggestions would be greatly appreciated.
Any suggestions would be greatly appreciated.