CREATEProcedure sp_mrx_truncatelog AS declare db cursor LOCAL forSELECT NAME FROM sysdatabases declare@dbnamevarchar(200),@sqlvarchar(2000) OPEN db FETCHNEXTFROM db into@dbname while(@@FETCH_STATUS<>-1) BEGIN if(@@FETCH_STATUS<>-2) BEGIN set@sql='BACKUP LOG '+@dbname+' WITH TRUNCATE_ONLY' print@sql exec(@sql) END FETCHNEXTFROM db into@dbname END CLOSE db DEALLOCATE db --print '------------' --print @totalcount GO