Return
-
Title
Error "SQL Query Produces No Results" collecting C2 Logs -
Description
If you see the error "SQL Query Produces No Results" during gathering of C2 audit logs from SQL 2000.
-
Resolution
If the database files are not located in the default location of "Program Files\Microsoft SQL Server\MSSQL\Data" then in SQL Enterprise Manager drill down to the SQL server and right click and go to properties, then go to the Database Settings tab and set the default Data Directory to the location of the C2 logs.