The user has uninstalled Spotlight for SQL Server Enterprise, but the user continues to see dumps being generated regularly with the following:
File: QS_IndexLogWaitCounts.sql --
* * -- * Copyright 2010 Quest Software, Inc. -- * ALL RIGHTS RESERVED.
* -- * -- * This software is the confidential and proprietary informatio
* n of -- * Quest Software Inc. ("Confidential Information"). You shall
* not -- * disclose such Confidential Information and shall use it only i
* n -- * accordance with the terms of the license agreement you entered
* -- * into with Quest Software Inc. -- *
The Quest Diagnostic Service is what calls QS_IndexLogWaitCounts.sql.
Spotlight on SQL Server Enterprise executes the QS_IndexLogWaitCounts.sql script when problem occurred. All the scripts the product uses are stored in the <Quest Software>\Diagnostic Server\Agent\conf\Package\sqlserver_spotlight location on the Diagnostic Server-machine. There are 3 subfolders there: 2000, 2005 and 2008; each contains set of scripts for corresponding version of SQL Server.
The user can do a full search on the computer under Start | Search on the entire drive for QS_IndexLogWaitCounts.sql
Then, delete it.
The next step is to go to the SQL Server Management Studios, ensure are no Workdatabase on the SQL Server in question.
If the user has dropped the Diagnostic Server Service from the machine. There is no Quest Diagnostic Server Service to stop.
If the user is still getting those statements with “QS_IndexLogWaitCounts.sql” , this means there is Quest Diagnostic Server service lingering somewhere else on a different computer. The user should also look at the Addl/Remove Programs and see if there is Diagnostic Server service installed on a different machine.