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...

I think DAS was coined when expansion boxes attached to servers using external SCSI connections. This distinguishes it from storage across a network using HBAs, SAN, iSCSI, etc.

You are correct...

Aside from what Lowell wrote, if you have truly filled up all the space with data, you'll need to archive data and then delete it to free up space.

I'd use the solution above to concatenate the values.