81 reputation
bio website me.com
location Isle of Man
age 34
visits member for 2 years, 4 months
seen Dec 1 '12 at 10:44

Support and DBA SQL server 2008

comment Sql Server - Best Practices for Growing Database Files
I remove the "AND instance_name = 'database your interested in" so it returns all databases. Then use a count where the log size is a above a threshold in the IF statement. If the count is higher than 1 I do a sp_send_dbmail with a select name statement from the temp table to email the names of the logs above the limit.