OK
ALTER TABLE dbo.SnRelationship ADD
GroupId uniqueidentifier NULL,
UserId uniqueidentifier NULL,
CampaignId uniqueidentifier NULL,
NewsCategoryId uniqueidentifier NULL,
NewsletterId uniqueidentifier NULL,
PageId uniqueidentifier NULL,
PollId uniqueidentifier NULL
did the trick but I got error when I have tried to set the foreign keys:
ALTER TABLE dbo.SnRelationship ADD CONSTRAINT
FK_SnRelationship_SnGroup FOREIGN KEY
(
GroupId
) REFERENCES dbo.SnGroup
(
Id
) ON UPDATE NO ACTION
ON DELETE NO ACTION
and the error is:
Msg 1776, Level 16, State 0, Line 2
There are no primary or candidate keys in the referenced table 'dbo.SnGroup' that match the referencing column list in the foreign key 'FK_SnRelationship_SnGroup'.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
After I have rested the personalization for the default page it seems to work OK.
Thanks for the help
This content has not been rated yet.
265
Reputation
29
Total posts