I have a question with regards to MSDE. We're testing some update software and downloaded the free version of MSDE. I know tools like QA or EM don't come with...

It doesn't mark the database as corrupt. It does tell you that there is a problem. I had to drop and rebuild an index recently to correct a problem that...

Why turn off torn page detection? It caught an issue on my production DB. I run CHECKDB nightly, and everything was fine. Midday, I got an email about a torn...

H,

Any luck? I'm having the identical issue on one of my SQL servers here. Same error when I try starting the SQL Server Agent. Thanks.

If never states what the path is or what it's looking for. The event viewer says the same thing "Path not found", nothing more. I'll try your suggestion with the...

That was one of the first things I checked. That's what's confuses me since I've done this process in the past and it's never failed before.

NTBACKUP

Do you have any tools at your disposal, like SpotLight? You can use QA and sp_who2 to find out what may be processing. Or in EM, go to Management->Current Activity->Process...

Idera also has a tool that I'm demo-ing, SQLsafe. It also encrypts and the price is right.

You can also use the maintenance plans and specify "All user databases". This way, as new databases are added, they'll automatically be backed up without any changes by you to the...

With my code, leap year birthdates were the culprits leading to the errors. Thanks for the suggestions.

Actually, that piece of code is returning the day of the week for their birthday this year. It works but if you have another method, I'm open to suggestions. Your...

I thought about that and checked all my configurations options. Outside of the one I mentioned, they are identical.

Mike, where does it put the results? Simply to the log?

Can anybody offer the syntax? I've tried several things and even searched Microsoft without any success. Thanks.