Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
new_to_ssrs
Starting Member
2 Posts |
 Posted - 2009-06-11 : 10:34:07
|
| Hello,I am creating a model based on a data source view which has all sql views (no tables). When I create the DSV, a primary key automatically gets defined for some of these views. The problem is, in some cases this primary key is incorrect and I want to change it but it doesn't let me do that. In the design view, when I select the field in the view and right-click, the "Set Logical Primary Key" and "Delete Logical Primary Key" options are grayed out. Any ideas on why this could be happening would be greatly appreciated. |
|
|
|
|
|
Cannot delete logical primary keys in SSRS DSV