Other workarounds include setting up the Alert system for errors x, y, and z. But you seem married to your script. And I don't know of any singular system db...

That's what the DBCC commands and the Alert system are for. You should only have to worry...

Also, check and see how often your job log clears itself out. That would be the reason why you're not seeing a history on the job.

Check the Configuration Manager for SQL Server. Someone may have turned off Named Pipes as a protocol.

EDIT: Also, check the box that the application is running on. Did someone turn...

So far as I know, there is no way to prevent it. Single User mode is used to prevent additional people from gaining access while certain maintenance activities are occurring....

Let's start from the beginning. Why do you want to write a script to do this?

Why can't you just have it read the most recent error log on each...

What Suresh didn't tell you is that databases upgraded to SQL 2005 can experience invalid page and row counts in the system catalog views. DBCC UpdateUsage corrects those counts.

However, if...

george sibbald (6/15/2011)

---

To avoid this problem in the future, next time your instance is down take a flat file copy of the system database files to another directory (including the...

Hashbytes seems overly complicated to me as well.

Steve Jones - SSC Editor (6/17/2011)

---

Cross your fingers, everyone. Horse vet called, ugly cut on the rear hind of a horse. I think it can be stitched, but you never...

GilaMonster (6/17/2011)

---

Which would you prefer?

1) Finding out the backup is damaged and unrestorable right after making it, when you can make another

2) Finding out the backup is damaged after the...

paul.knibbs (6/20/2011)

---

But if the Sybase DATETIME is only accurate to 1/300th of a second, it CAN'T be using any old values for the thousandths--0.001 would make no sense because the...

SQLRNNR (6/17/2011)

---

Yeah it seems...

Wow. PASS people have been busy the past two weeks. I've gotten more SQL Saturday speaker request notifications than I can shake a stick at!

GilaMonster (6/17/2011)

---

Off to the UK for a week and a half. Can some people keep an eye on the corruption forums make sure that any problems don't get unchallenged stupid...