(Simon Sabin) Alerts in SQL server rely on the error being logged to the event log. Not all system messages are logged which means you can’t alert on them. In SQL 2000 you could hack the sysmessages table, however in SQL2005 you can’t.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help