[dbo].[UpdateDocumentNameExtensionOnly]

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@inMSSDocumentID	int	4
@inNewDocumentName	nvarchar(128)	256

Type	Action	Owning Principal
Grant	Execute	MssExec

SQL Script

/*
* Description: Used to update the file extension of a document when Atlas is able to convert an
* image into a .pdf file.  Also updates the associated DocumentUploadStatus (if any).
**/
CREATE PROCEDURE [dbo].[UpdateDocumentNameExtensionOnly]
    @inMSSDocumentID int,
    @inNewDocumentName nvarchar(128)
as

set nocount on

declare @theOldDocumentName nvarchar(128)
declare @theOrderID int

update MSSDocument set
    @theOrderID = OrderFID,
    @theOldDocumentName = DocumentName,
    DocumentName = @inNewDocumentName
where MSSDocument.MSSDocumentID = @inMSSDocumentID

update DocumentUploadStatus set
    DocumentName = @inNewDocumentName
where OrderFID = @theOrderID and
    DocumentName = @theOldDocumentName
GO
GRANT EXECUTE ON  [dbo].[UpdateDocumentNameExtensionOnly] TO [MssExec]
GO