TFS 02 - Mark SP

CREATE PROCEDURE SP_SetTransactionLogMark
    @name nvarchar(128)
AS
    BEGIN TRANSACTION @name WITH MARK
    UPDATE dbo.TBL_TransactionLogMark SET LogMark = 1
    COMMIT TRANSACTION
GO