Search for SQL Server events

The Find window, accessed by clicking Search, allows you search for text in the event messages. 

To search for text in your Server logs:

1. Click Search on the Logs tab.
2. Enter the search term in the Find what field.
3. Select the field you want to search (Message, Msg #, or Source) from the Look in drop-down list.
4. Select your Find options.
5. Click Find Next.
6. Keep clicking Find Next to scroll through the matches to locate the specific event.