Problem:
When you see "There is already an object named 'sqlsrv_cpu' in the database" message in the sqlserver problem log.
Environment:
- MS SQL Server 2000
- sqlserver probe version 4.20 and below
Cause:
If in the sqlserver.log you see the following entry:
Mar 1 05:37:57:187 [60644] sqlserver: Profile: pe400sc/server_cpu/Run Query - DB Provider: Code=0x80040e14 Source=Microsoft OLE DB Provider for SQL Server Description=There is already an object named 'sqlsrv_cpu' in the database.Description=There is already an object named 'sqlsrv_cpu' in the database.
Resolution:
Download and deploy sqlserver prove version 4.21 or above.
It contains the following fix: "Fixed an issue where sqlusr_cpu store procedure are not deleted after executing querys in case of SQL Server 2000"
Additional Information:
http://support.nimsoft.com/unsecure/archive.aspx?id=89