Wednesday, August 6, 2008

SQL 2005 Bug - E-mail report multiple times, multiple = # of user dbs available

I finally figured out what is happening to my reports. One maintenance task is being reported a number of times when maintenance task runs. If you specify "all user dbs" instead of "these dbs" and selecting each user db separately, report will be e-mailed multiple times, depending on how many user dbs you have. I've opened a case with Microsoft previously on this matter but could never explain it right to them. This made my day!
Post a Comment