Hello DNN experts,
I am trying to delete a line in the table dnn_packages due to a misconfiguration in one of the loaded skins
as I run :: delete from dnn_packages where PackageID = 144
I get the error : Msg 40054, Level 16, State 1, Line 2
Tables without a clustered index are not supported in this version of SQL Server.
Please create a clustered index and try again.
Of course, table dnn_packages have index, therefore if I try to recreate them, SQL reply so.
I have try with both :
CREATE UNIQUE CLUSTERED INDEX Idx_dnn_packages ON dnn_packages(PackageID);
ALTER TABLE [dbo].[dnn_packages] ADD PRIMARY KEY ([PackageID]);
obviously, in both cases, the system respond:
Cannot create more than one clustered index on table 'dnn_packages'.
Drop the existing clustered index 'PK_Dnn_Packages' before creating another.
Table 'dnn_packages' already has a primary key defined on it.
Is there any dependency, or reason, by design, becouse DELETES form Dnn_Packages are not allow ??
Note:
I got inspired from the following post, to try to delete the line in dnn_packages:
http://www.dnnsoftware.com/forums/forumid/109/threadid/289839/scope/posts