How to manage or view SQL Server messages (Enterprise Manager)

To manage or view SQL Server messages

1. Expand a server group, and then right-click a server.
   
   
2. Point to All Tasks, and then click Manage SQL Server Messages.
   
   
3. To specify search options, do one or more of the following:
   • In the Message text contains box, type the text to search for.
     
     
   • In the Error number box, type the error number to search for.
     
     
   • Under Severity, select a severity level to search for.
4. To specify the messages to include, do one of the following:
   • Select the Only include logged messages check box.

   -or-

   • Select the Only include user-defined messages check box.
5. Click Find to find all messages that match the search criteria.