yes

If the decryption doesn't work, you'll get a NULL. This is poorly documented in BOL, so that's likely your issue.

A couple questions.

1. Are you casting the decryptbykey result to the...

Congrats

Jeff Moden (7/3/2016)

---

From what I've heard, it's because they don't...

You cannot attach the same database to two instances. You can attach two copies to different instances, but when you attach the database, the SQL Server service takes an exclusive...

There's a few articles on JSON here, including some pre-SQL 2016 - http://www.sqlservercentral.com/articles/SQLCLR/74160/

What do you mean by #4? Take a backup from each instance? There isn't a thing as an instance-database. If you want to take a backup from each instance, you...

Does this help: http://www.somacon.com/p586.php

Is there more code for the alert? That will track status, but not alert for disabled.

It is possible that a wrong password can lock an account, check the policy on...

Did you run the SQL Server install? Did you run the SSMS install?

Do you have a service called MSSQL running?

Jeff Moden (6/29/2016)

---

GilaMonster (6/29/2016)

---

Jeff Moden (6/28/2016)

---

Steve Jones - SSC Editor (6/28/2016)

---

Jeff Moden (6/25/2016)

---

While I agree that it probably has fewer bugs...

Arrggghhhh, my idiocy here. I didn't check the box for HierarchyID.

Points awarded back.

My apologies.

manie (6/28/2016)

---

Steve, that there is my problem with Microsoft. If I develop an application...

Beatrix Kiddo (6/29/2016)

---

In the Venn diagram of the UK, all English people are British, but not all British people are English :-D. One of the best way to wind up...

Excellent