spDelete_SiteContent

Parameters

Parameter	Parameter Type	Mode	Description
@PKID	int	IN
@CurrentUsersID	int	IN

Definition

Copy


CREATE    PROCEDURE [dbo].[spDelete_SiteContent]
(
        @PKID        int,
        @CurrentUsersID    int
)
AS
    declare @Guid uniqueidentifier

    begin transaction

        DELETE FROM SiteContent WHERE ID=@PKID

        DELETE FROM Search Where SiteContentID = @PKID

        select @Guid = Guid from SiteContent where ID = @PKID

        exec spDelete_ObjectSecurity @Guid

/*        UPDATE SiteContent SET Deleted=1 where ID = @PKID

        exec spAuditThis @CurrentUsersID, 3, @Guid, 1 */

    commit