OK, just to tie up loose ends, we did end up applying the hotfix yesterday. Of course, despite what the documentation said, it wanted a reboot of the server....

We're on: Microsoft SQL Server 2005 - 9.00.3054.00 (X64) Mar 23 2007 18:41:50 ...

OK, thought I was all set...but of course, it's never that easy. I get this error in the log:

Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException

Message: The read on the database failed. Reason: Failed...

If I get a "1" as a result from the query

SELECT is_broker_enabled

FROM sys.databases

WHERE name = N'msdb';

then I don't even need to stop the SQL Server Agent, is that...

I was told you'd actually get back incorrect results occasionally from the first way...was just wondering if that was the case in 2005 - or maybe I was just told...

Jeff Moden (4/15/2008)

---

Sean... take a look at Books Online... most of the examples given are just flat wrong... for example...

[font="Courier New"]SELECT @COL = CASE @Section

...