There is a duplicate data for that column where user is trying change it. Yes, it is a key column of composite primary key. and also it is unique non clustered index.
Any way, thanks for your help. I am really sorry for this.
I got a small concern in this issue. User is asking me to allow duplicates in the column which has Unique Non-clustered index. If I remove that index to the table then it will not be a problem for that table.
But my concern here is that if we remove that index on key column I am not sure what will be the potential issues for the application.
I don't have much experience on Database design part, so Please let me know how to know the potential impact if I remove that key column?
if any thing goes wrong, all users come back to hit my head?
Unique Non-clustered Index is just like a constraint, I believe. So if I remove that index, it means we can enter the same data again and again, but it will not affect the Primary key's functionality as it is part of a composite primary key.
Please give any suggestions to proceed?
Thank You