Could be either one. You need a master key for TDE or column level stuff.

Do you have a DMK? Run this:

SELECT

db.name,

db.is_encrypted,

...

If you're feeling the itch and things are slow.....

Looking for good questions of the day and articles on practical topics.

Just got a CDC article that covers setup, but not...

Encryption as in column level encryption (symmetric/asymmetric keys) or TDE?

I always want a datetime here so that I can detect latency or potential issues with my process. I'd store this on the destination side, when I pull the data....

It should be. Perhaps something is broken here, but there should always be two pools on all instances.

Be aware that anyone can spoof the application name in their connection string. In practice, it probably doesn't happen, but just be aware you have a hole.

I don't think there's an issue here. There might be a small conversion, but it can't be much. There can't be a "bit" in the register. It will load as...

I'm here. Around a doctor's appt for my...

Happy New Year!

Also, I can repeat column names. Just need an alias.

SELECT a.myid

, a.mychar

, b.myid

FROM dbo.mytable2 a

INNER JOIN dbo.mytable b

ON...

As Chris mentioned, we can't determine how you match up rows. What determines that the row with "a" matches the row with "c" and not "d"? If you can't logically...

'donks

Boo, Pats

chrisn-585491 (12/31/2014)

---

As a Jack-of-All-Data-Trades, certification is huge time suck for me. As soon as I'm ready for an exam, it's retired and there's yet another two new versions of SQL...

You are...

As Lowell suggested, I'd use SQLMail.

We used to send the newsletter here from SQL2000. It can be done at lower volumes (1,000s/day).

What I'd do is load an email table with...