DMVstats: Purge DMV Samples & Alerts
description
Installed DMV Stats on SQL Server 2005:
productversion -->9.00.3054.00
productlevel --> SP2
edition -->Developer Edition (64-bit)
Trying to execute manually the job:
[SQLSTATE 01000] (Message 50000) Invalid object name 'DMVsample.query_stats'. [SQLSTATE 42S02] (Error 208) Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 0, current count = 1. [SQLSTATE 25000] (Error 266). The step failed.