Microsoft recommends that you set the following registry key on production SQL Server computers to avoid the chance of receiving messages:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Windows\ErrorMode Value = 2
The value of 2 instructs the Windows NT operating system to avoid popup messages for any hard error on the system and return the default error condition to the calling process.
This registry key is always checked before any hard error is received. Therefore, you do NOT have to restart the system after changing the key value. You can immediately reset the key back to 0 if any unexpected side effects occur.