sql server msde: Hi Everyone,

One of my clients started getting error messages in their "Database
Maintenance Plan" that has me concerned.

Databases: master & msdb (two error messages but same codes)
Activity: Check Data and Index Linkage
Error number: 7919
Message: Repair statement not processed. Database needs to be in single
user mode.

I checked Microsoft knowledgebase and it appears that this is a known issue

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q290622

What concerns me is this never happened before to any of my clients and
it seems serious as it affects key system databases Master and msdb.

Should I be worried?

Thanks

Hi Andrea,

I suspected as much, but I wanted confirmation from the experts :)

Maybe I'll convince them to upgrade to SQL 2005 later in the year.

I know ISA 2004 will be included in SBS SP1 for free! (expected to be
almost 400M!) Do you think Microsoft would be generous with SQL 2005 or
maybe offer it at a reduced price for SBS 2003 users?

Thanks for your help

Richard



[quoted text, click to view]