Hello Chris:
I just ran the following code using the SQL page in DNN:
"if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}Forum_UserDeleteReads') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}Forum_UserDeleteReads
GO
if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}Forum_UserThreadsDelete') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}Forum_UserThreadsDelete
GO
CREATE PROCEDURE {databaseOwner}{objectQualifier}Forum_UserDeleteReads
@UserId int
AS
DELETE FROM {objectQualifier}Forum_UserThreads
WHERE UserID = @UserId
DELETE FROM {objectQualifier}Forum_UserForums
WHERE UserID = @UserId
GO
CREATE PROCEDURE {databaseOwner}{objectQualifier}Forum_UserThreadsDelete
@UserID int,
@ThreadID int
AS
DELETE FROM {objectQualifier}Forum_UserThreads
WHERE
UserID = @UserID
AND
ThreadID = @ThreadID
GO"
Isn't this the fix? Do I need to restart my application or so?
Thanks,