Hi All,

Odd problem repeatable as follows:

Connect to DB
Begin transaction
.....
Commit (using SQLTransact)

Now the Commit returns SQL_SUCCESS_WITH_INFO and after
calling the SQLDiag calls, this turns out to be sysmessage
6002 "Shutdown is in Progress...". Now, the commit return
status says success but, it has actually failed. Now,
after looking at MSDN, I find an KB article (301642) that
says that SQL Server is returning this message with the
incorrect severity (10 instead of 16). If it was 16, I
would get SQL_ERROR and I would be happy. Now, according
to the article this has been fixed since service pack 2
but, if I do a select from the sysmessages table, I find
it still has a severity of 10 (and hence, why I am still
getting this message). Does anybody know if you have to
get a hotfix for this separate to the service packs?