Probably no real way to prevent it while using MERGE then. It just doesn't have much flexibility. You'd need to have a read in place to prevent the insert, and,...

It's a pretty good rule to not RDP into production servers unless you absolutely have to. Most of the SQL Server and database administration can be done remotely from SSMS.

tcronin...

Are there external processes running on the server like virus software? Do you have a minimum for memory? Assuming an external process started using up either CPU or memory, your...

Make sure you have a unique constraint to prevent getting duplicate values.

Eric Prévost (4/8/2015)

---

OP's job calls a procedure part of Ola Hallengren's SQL Server maintenance plan.

Using sqlcmd.exe is recommanded for proper error handling (From https://ola.hallengren.com/frequently-asked-questions.html):

Do the stored procedures need to be...

Researching which tools to use is, depending on the size of the organization, an architecture role. Usually that's filled by people with a lot more than 2.5 years of experience....

Pretty sure it's because sqlcmd expects it all to be on a single line. Since you're calling this through Agent, couldn't you skip using sqlcmd? Just asking.

And here we part ways.

Koen Verbeeck (4/8/2015)

---

Koen Verbeeck (4/8/2015)

---

Grant Fritchey (4/8/2015)

---

Probably get in a little trouble for this, but since I know that many of you are both SF fans and, let's just say,...

Koen Verbeeck (4/8/2015)

---

Grant Fritchey (4/8/2015)

---

Probably get in a little trouble for this, but since I know that many of you are both SF fans and, let's just say, not on...

xsevensinzx (4/8/2015)

---

Grant Fritchey (4/8/2015)

---

Jack Corbett (4/8/2015)

---

Brandie Tarvin (4/7/2015)

---

Eirikur Eiriksson (4/7/2015)

---

Jeff Moden (4/7/2015)

---

I'd put off doing anything with SQL Server 2012 until I actually needed it. I'm doing...

Probably get in a little trouble for this, but since I know that many of you are both SF fans and, let's just say, not on the same wavelength as...

Jack Corbett (4/8/2015)

---

Brandie Tarvin (4/7/2015)

---

Eirikur Eiriksson (4/7/2015)

---

Jeff Moden (4/7/2015)

---

I'd put off doing anything with SQL Server 2012 until I actually needed it. I'm doing installs for upgrades...

If you mean that you need to track actions within the database, you should look to Trace or Extended Events to capture the queries that are performing actions that you're...

Reverse that order logically and you should have your answer. You need to delete all the child table rows, then delete the parent.