Sweet

I'll be there.

use the entire path when trying to call 2012 ssms

"C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe"

Jeff Moden (10/2/2013)

---

I struck out my previous comments. I don't know what happened last night but I can't seem to duplicate the problem today. I hate it when...

Why would you want to have the dev database perfectly in sync...

jasona.work (10/2/2013)

---

So, just saw a story that indicates Tom Clancy may have passed away.

I quite enjoyed Red Storm Rising and Hunt for Red October. Sum of All Fears was...

It is probably a university course. It is not too far...

To me it looks like all of the arrows are going in the wrong direction.

You have a class that populates a dataset and that class also gets shipped off to...

I'm with Jeff. Keeping dev in sync with prod is a bit of a problem.

Grant Fritchey (10/1/2013)

---

GilaMonster (10/1/2013)

---

SQLRNNR (10/1/2013)

---

Good.

I'll...

I wonder how well that trigger in the msdb database would work.

Some have really hit hard on a crucial piece to this problem - controls and audit.

I agree that if...

andrew gothard (10/1/2013)

---

crmitchell (10/1/2013)

---

assuming your c: drive is only used for the OS could you use disk quotas in windows to limit the amount of disk space visible such that...

halifaxdal (10/1/2013)

---

Scott Coleman (10/1/2013)

---

Here are two versions, column lists removed for clarity. Don't rely on "SELECT *" to work across servers.

-- V1: Copy the entire remote table, keep only...

thanks for the question.

L' Eomot Inversé (10/1/2013)

---

WayneS (10/1/2013)

---

Well, lets just say that...

Stewart "Arturius" Campbell (10/1/2013)

---

I remember SQL 2008 & R2 and 2012 warning that this will be removed in a future version. It appears that 2014 still carries that warning.

I wonder...