• This is the stored procedure that runs the 'Truncate Transaction log'

    ALTER PROCEDURE [dbo].['name of stored procedure']

    AS

    BACKUP LOG 'Databasename'

    WITH

    TRUNCATE_ONLY