Have you also run a dbreindex on the affected database recently? If so, check: http://support.microsoft.com/default.aspx?scid=kb;en-us;816084&Product=sql which details the same error message that you describe.

This looks like a known bug...

I think it mostly depends on your hardware and user base.

From BOL regarding the connections option:

"Important If you must use this option, do not set the value...

For SQL Server 7.0 you can use this link: http://www.mssqlcity.com/FAQ/Devel/DecryptSP.htm

For SQL Server 2000 there is another utility here: http://www.exhedra.com/URLSEO/vb/scripts/ShowCode!asp/txtCodeId!505/lngWid!5/anyname.htm.

Hope this helps.

uhhhhh....did I say 'people who don't proof read their work' before? That should have been 'emergency'

The posts on the previous page reminded me of a couple more things...

Managers who claim to be technically competent, apply patches to servers in the middle of the night, don't...

LOL at Lee's post. Maybe time to 'table' this.

"Remember to take credit for the good things you say and do." Anonymous

Thanks Kevin. From what I've seen, I'd have to agree that it seems to occur concurrent with the log dumps. I guess if I get really annoyed with...

Thanks Mark,

Good idea, but that's not an option in 7.0 unfortunately. When I try it from a 2000 client, I get an error saying it can't execute due to...

I set it to 150 mb again and will see what happens in the morning. It's been 45 minutes since the last log dump and only 8 mb of...

There's nothing in EM and I've only set up the routine type jobs. I queried msdb.sysjobs just to be sure, but it only lists the the maint. plan jobs...

I posted a similar topic a few weeks back and didn't get back much in the way of replies. Everyone agrees it's a bad idea, but there's not much...

In honor of Frank, I'll be asking for a Spaten at my local watering hole tonight. Or maybe it will be a Warsteiner depending on which pours best. ...

I've seen a few mentions in this thread about management and I guess my chief complaint where I am is that it tends to be re-active rather than pro-active. ...

I've seen this issue in posts before and have also experienced it myself. I believe it's a problem with the client connection and not related to any database settings....

Frank - forgive me please for not exlpaining Pet Peeves better, but you got it dead on anyway.

I have a new car but don't smoke...