I've got a SQL 2005 Reporting Services database that has been migrated from SQL 2000. On creating a custom subscription on any report i get the following message:
"Violation of PRIMARY KEY constraint 'PK_ScheduleID'. Cannot insert duplicate key in object 'dbo.Schedule'. The statement has been terminated." Shared subscriptions do not give this error. I have deleted all subscriptions, effectively emptying the table, yet i still get the same error? I can get this error on the console as 'sa', 'admin' or a 'user' All the columns concerned seem to be uniqueidentifier type. Any ideas on why this error is occurring?? or how to re-seed/reset this GUID, given it's not an identity??? or how i can trap the details of this insert (wizard) to track down the duplicate??? I cannot find this issue reported anywhere. All other RS functions work fine??