Merry Christmas and/or Happy Holidays to everybody who survives.

GSquared (12/13/2012)

---

Really? I always just assumed a Jawa...

I think Jawas and Ewoks must be descended from common ancestry. They both have an identical IIEEEEYAAAA war cry.

Prester John

purgatory

Budget cuts are the reason the first Death Star didn't have a grate or something covering the exhaust port.

camembert

Doc

Transpose

re.re.re.res

Think maybe changing from [mirroring_state] to [mirroring_role] had something to do with it? Your where clause could be logically rewritten as

WHERE (d.database_id >= 5)

...

I feel compelled to add this. As a general rule, you should not test against functions like ISNULL, because that can prevent the optimizer from taking advantage...

Select

d.name,

d.compatibility_level,

m.mirroring_state,

mirroring_role_desc

FROM

sys.database_mirroring M inner join SYS.DATABASES d

on m.database_id = d.database_id

where D.database_id >=5

and ISNULL(mirroring_role_desc,'') like CASE WHEN M.mirroring_state is NOT NULL...

sunshine-587009 (12/7/2012)

---

Here's my updated script with correct aliases and your suggestion.

Select

d.name,

d.compatibility_level

FROM

sys.database_mirroring M inner join SYS.DATABASES d

on m.database_id = d.database_id

where D.database_id >=5

...

sunshine-587009 (12/7/2012)

---

Good afternoon everyone!

I'm not a regular developer so please excuse my question for being easy for what would be a good developer.

I'm trying to create a statement that returns...

Bulldog