How do I manually delete events from the repository? (NETIQKB6903)

How do I remove items that I don't want without using the Operator Console?

To manually remove events from the repository:

1. Record the Event ID for each event you want to delete.
2. Open SQL Server Query Analyzer.
3. Select the repository (QDB).
4. Enter the following SQL statements:
   
   
                DELETE
                FROM EventDetailAction
                WHERE EventID = xx 
    

   Where xx is the Event ID noted from Step 1.

5. Press F5 to execute the SQL statements.
6. Enter the following SQL statements:
   
   
             DELETE
             FROM EventDetail
             WHERE EventID = xx 
    
   Where xx is the Event ID noted from Step 1.
   
7. Press F5 to execute the SQL statements.
8. Enter the following SQL statements:
   
             DELETE
             FROM Event
             WHERE EventID = xx
   

   Where xx is the Event ID noted from Step 1.

9. Press F5 to execute the SQL statements.
10. Repeat steps 4-9 for each event you want to remove.

Formerly known as NETIQKB6903