I checked your error messages online, and it appears that this is most likely a problem with the service account accessing the Windows Registry. It's either using an account...

Those messages are definitely SQL Agent updating the data it uses for its reports and such.

Do you have a lot of jobs running? Or a few jobs running very,...

Can you post the actual error message?

Stefan Krzywicki (7/29/2011)

---

GilaMonster (7/29/2011)

---

I do very little productive on the phone. It's great for shopping lists, much reduces the chance I'll write a list and leave it at home. Twitter...

It gets worse than just accents.

I've had a multitude of people assume I'm not American, because I "speak well" instead of "talk good".

Start with the last one. It says you're missing a database on an instance of SQL Server. Have you checked to see if that database exists on that...

That means you're trying to overwrite an existing database, while it's in use.

You'll need to take it offline, or set it to single-user and use that credential to run the...

RAID-1 can definitely be more than 2 disks. It's just more redundancy, not more space. It means sequential writes, but some controllers will be able to do parallel...

I'd say go for it. You said you have access to a mentor there, plus you have this site and others even if he's not available.

I have had perks like that. Had the data portion of my cell phone bill covered as well, to cover company e-mails to my personal phone. (Was cheaper...

Change this:

WHEN (E.ShiftDesc = ('AM','PM')) Then

to:

WHEN (E.ShiftDesc in ('AM','PM')) Then

You can't use "=" to check multiple values, you have to use "in" for that.

I'd contact MS about that one. Sounds like a bug to me.

You're welcome.

TravisDBA (7/27/2011)

---

cengland0 (7/27/2011)

---

GSquared (7/26/2011)

---

Most company owners/managers won't get that "English" is actually a set of just barely recognizable languages, not just one. Easiest way to explain it to them...

With my query, yes, I got the comparison operator backwards.

If you want to ignore ties, use Row_Number instead of Dense_Rank. Will cut off otherwise valid records if you have...