Maintenance error in CM 07?

I can also add that we have noticed that the above leads to a stored
procedure, sp_DeleteOldSDMPackageData in SMS_STO database. Creating a
small routine in SQL Query window that's calling the
sp_DeleteOldSDMPackageData with the parameter value = 3, creates the
following:

Msg 530, Level 16, State 1, Procedure sp_DeleteOldSDMPackageData, Line
18
The statement terminated. The maximum recursion 100 has been exhausted
before statement completion.

Then we are stuck.

Anyone???


On 18 Sep, 16:52, spaceu...@yahoo.com wrote:
> Hi!
>
> Receives maintenance error (taken from SCOM 2007), which I thought was
> a SQL Server 2005 error but is a CM 07 server error, according to a
> SQL expert. See below:
> ===
> ConfigMgr 2007 Status: Database Notification Monitor failed to execute
> a Site Maintenance task. A new monitored SMS status message on machine
> SACHS from component SMS_DATABASE_NOTIFICATION_MONITOR with message ID
> 2401 was found in the site STO database. The status message contains
> message properties Machine Name: SACHS Module Name: SMS Server
> Component:
> SMS_DATABASE_NOTIFICATION_MONITOR Message ID: 2401 Win32 Error:0 Top
> Level Site Code: Database Record ID:9656312
> ===
>
> I have no clue on what this is and what to do. I would appreciate any
> comment on this
>
> TIA

Hi!

Receives maintenance error (taken from SCOM 2007), which I thought was
a SQL Server 2005 error but is a CM 07 server error, according to a
SQL expert. See below:
===
ConfigMgr 2007 Status: Database Notification Monitor failed to execute
a Site Maintenance task. A new monitored SMS status message on machine
SACHS from component SMS_DATABASE_NOTIFICATION_MONITOR with message ID
2401 was found in the site STO database. The status message contains
message properties Machine Name: SACHS Module Name: SMS Server
Component:
SMS_DATABASE_NOTIFICATION_MONITOR Message ID: 2401 Win32 Error:0 Top
Level Site Code: Database Record ID:9656312
===

I have no clue on what this is and what to do. I would appreciate any
comment on this

TIA