I agree with a couple of folks above that SQL Sentry is a good 3rd party tool. It's proven itself in our large scale environment. It's monitoring is very reliable...

All queries failed due to missing Owner/Schema.

Example:

Invalid... "FROM HumanResources.Employee"

Valid... "FROM HumanResources..Employee"

Valid... "FROM HumanResources.dbo.Employee"

Please review this and award points...

The Suicide Hotline was busy, what's a maniac to do! I didn't get my point back, so I am suffering depression. I'll try slicing my wrists this time, maybe that'll...

smunson (6/23/2008)

---

Actually, that "old adage" has a rather seriously gaping hole in it - such that it renders ALL judgements invalid simply because everyone is imperfect. A total...

You forgot one...

___ Donate to starving DBA.

😀

I also chose the correct answer #2. Please give us our points back:angry::angry::angry:

On this website you have to guess is "sp_decribe_cursor" a typo or a trick question? Just so happens it's a typo.

Hopefully, everybody gets points.

I live on the Darkside of "Alpha Centauri C". What is daylight?

I understand the True, False, Unknown of Null evaluations. However, It's not UNKOWN to me.

1. Will I receive results from the query? -- FALSE
2. Did...

Jeff,

If the where clause is only true when the expression is true, then it's FALSE.

If NULL = NULL

    Print 'True'

Else

    Print 'False'