• fn_dblog changed slightly between SQL 2005 and SQL 2008. This was, of course, without notification or documentation. If I remember correctly, it changed from 2000 to 2005 as well. I don't know if it's changed from 2008 to 2008 R2, but it could have. Also haven't checked Denali (SQL v 11) yet.

    I've used it to test for whether a log backup was needed on databases that have intermittently high activity in long periods of no activity, comparing LUNs in the log to data in the backup history in msdb. Even then, I wouldn't use it in anything where an error message mattered much. Too much chance of it changing again.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon