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

How to Install SQL Server 2000

How To

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.