51 reputation
3
bio website me.com
location Isle of Man
age 33
visits member for 1 year, 7 months
seen Dec 1 '12 at 10:44

Support and DBA SQL server 2008


Nov
24
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.