BLandry474 (10/21/2016)

---

My apologies Brandi - you're right - you did say that in your edit. However, you also just addressed constraining the columns entry when I asked a very...

BLandry474 (10/21/2016)

---

My thanks to all who responded, but please, in the future, read the question - I DID NOT say "Users are entering data", what I said was "We get...

Okay. Maybe it was the checks that screwed me up the last time I tried.

Thanks for the verification. I appreciate it.

HanShi (10/21/2016)

---

Eric M Russell (10/20/2016)

---

So, you're saying that the users are entering values that are considered invalid due to their excessive length? You can avoid this by implementing check constraints...

Lins,

I think you misunderstand what Grant meant by cross-database querying.

If you separate out...

jasona.work (10/20/2016)

---

Brandie Tarvin (10/20/2016)

---

jasona.work (10/20/2016)

---

Brandie Tarvin (10/20/2016)

---

I don't quite feel your pain, but I'm in the midst of migrating a handful of DBs to a new server. One is...

Luis Cazares (10/20/2016)

---

mister.magoo (10/20/2016)

---

I was wondering whether all this complexity is worth it...just to run a dtsx? But I'm not a DBA, so I assume this is a small part...

jasona.work (10/20/2016)

---

Brandie Tarvin (10/20/2016)

---

I don't quite feel your pain, but I'm in the midst of migrating a handful of DBs to a new server. One is ~134GB of data,...

jasona.work (10/20/2016)

---

Brandie Tarvin (10/20/2016)

---

On a fun note, my past 24 hours has been taken up by an AG issue which has caused one secondary replica not to synchronize, which caused...

lindsayscott23 (10/20/2016)

---

...our workflow goes like this:

Build in Dev

Unit Test in Dev (this is done by the developers)

Add to appropriate folder in TFS (we have monthly releases and each release folder...

Jeff Moden (10/19/2016)

---

Steve Jones - SSC Editor (10/19/2016)

---

Jeff Moden (10/18/2016)

---

Using compress backups and having a really good team that put together some remarkable hardware, I'm backing up 2.3 TeraBytes to...

Luis Cazares (10/19/2016)

---

Brandie Tarvin (10/19/2016)

---

Have you tried renaming the folders to use underlines instead of hyphens?

I think the hyphens are the problem. That powershell might see them literally as a...

On a fun note, my past 24 hours has been taken up by an AG issue which has caused one secondary replica not to synchronize, which caused the log files...

Gazareth (10/19/2016)

---

Gazareth (10/19/2016)

---

First line: "Version 4.2 also lets you nest triggers"

I didn't get any further due to blacking out; came to 10...

river1 (10/18/2016)

---

Separated sql tasks means that each species is executed inside is sql tasks. Task are connect through success arrows ( green arrows). So, exactly as the sp I...