spDelete_ClientSites

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

    begin transaction

    /*
    TRW 02/12/09
    Going to perform soft deletes for now. Please consider the
    effects if this gets changed back to a hard delete.
    All the content and pages, which may be shared across sites
    would get cascade deleted. Good and bad obviously.

    delete from clientsites where id=@PKID

    */

    UPDATE ClientSites SET Deleted=1 where ID = @PKID

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

    exec spAuditThis @CurrentUsersID, 3, @Guid, 8

    commit