I get this message in the sqlserver log: "There is already an object named 'sqlsrv_cpu' in the database"

book

Article ID: 35044

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

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

Environment

Release: CNMSPP99000-7.6-Unified Infrastructure Mgmt-Server Pack-- On Prem
Component: