Not sure if there was a misconception but to clarify the WITH NOCHECK option only applies to the initial creation of the FK, not later updates. If the column with...

Jeff Moden (3/26/2013)

---

Michael L John (3/26/2013)

---

Wow. I started a war.

Do all of you realize that you are saying the same things, but in different contexts?

Security is not something simple,...

Michael L John (3/26/2013)

---

Wow. I started a war.

Do all of you realize that you are saying the same things, but in different contexts?

Security is not something simple, and to...

Jeff Moden (3/26/2013)

---

opc.three (3/25/2013)

---

Jeff Moden (3/25/2013)

---

opc.three (3/24/2013)

---

You're still hung up on 'external attackers.' The point is, xp_cmdshell is a blunt tool that cannot be audited and allows people to run...

Jeff Moden (3/26/2013)

---

opc.three (3/26/2013)

---

Not only are you crass in your delivery but your advice is irresponsible and dangerous. Please keep the mischaracterizations to yourself. You're doing a disservice to the...

When running the service as a named domain account the SPN must be registered to the domain account which is why you do not see it when you ask to...

If you post the Actual execution plan for one of your long running updqtes that would help too.

I had a couple other questions too. What was the data type of the column you were updating and what was the nature of the...

Not only are you crass in your delivery but your advice is irresponsible and dangerous. Please keep the mischaracterizations to yourself. You're doing a disservice to the community and are...

It is worth noting that the solution provided requires you enable xp_cmdshell, which is disabled by Microsoft by default when you install SQL Server and for good reason. Enabling it...

*yawn*

Sergiy (3/25/2013)

---

Lack of answers on direct questions from me and Jeff.

You have nothing to support your words.

Seriously, where are you going with it Sergiy?...

Sergiy (3/25/2013)

---

opc.three (3/25/2013)

---

😛 You just made my point for me. I think we're done here...

The SQL is only doing what it is told to do by the .NET, i.e. to end the session because the .NET gave up waiting and closed it's connection. There...

Greg Shinder (3/25/2013)

---

Hello,

I am looking for a good (if any) way to log the event of transaction rollback. I'am on SQL2008 R2 Standart.

Situation:

Transaction is opened from .NET application. Request timed...