spClone_Documents

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@CloneContentID	int	IN
@ClonedContentID	int	IN
@CurrentUsersID	int	IN
Definition

Copy

        CREATE Procedure [dbo].[spClone_Documents]
        (
        @PKID int output,
        @CloneContentID int,
        @ClonedContentID int,
        @CurrentUsersID int
        )
        as

        BEGIN TRANSACTION

        DECLARE @NewGuid uniqueidentifier
        SET @NewGuid = NEWID()

            Insert into DocUploadPart
              (SiteContentID,
               [Name],
               [Description],
               [MaxSize],
               UploadCaption,
               RequiresApproval,
               Guid,
               [MimeTypes],
               [UseMimeTypes]
              )
             Select @CloneContentID, 
              [Name],
              [Description],
              [MaxSize],
              UploadCaption,
              RequiresApproval,
              @NewGuid,
              [MimeTypes],
              [UseMimeTypes]
             From DocUploadPart
             Where SiteContentiD = @ClonedContentID

        SELECT @PKID = @@Identity

        DECLARE @OldGuid uniqueidentifier
        SELECT @OldGuid=Guid FROM DocUploadPart WHERE SiteContentiD = @ClonedContentID

        -- DMB CR268456-022807: Security rights were not copying
        exec spClone_RoleObjectPrivs @OldGuid, @NewGuid

        exec spAuditThis @CurrentUsersID, 1, @NewGuid, 1

        COMMIT