The namespace doesn't seem to be associated to the root node - so if you can - add another dummy namespace for the outer Document node.

by casting to an NVARCHAR(4000) you are truncating the column. as per the error your error is at position 72,391,969 (substantially larger than 4,000 characters). So your inbound...

David.Poole (3/2/2016)

---

Humans are good at spotting patterns even when there isn't one.

An algorithm will be applied consistently and with out bias or prejudice.

Can you fool them if you...

Kyrilluk (3/2/2016)

---

I don't want things public. That creates issues. But they need to be able to be audited, independently.

Can two experts disagree? Sure. We see this all the time in...

djackson 22568 (3/1/2016)

---

Steve Jones - SSC Editor (3/1/2016)

---

My point, perhaps poorly made, was that algorithms can be well or poorly implemented. They can be beneficial or harmful, or even malicious,...

Agreed with all previous comments on getting the right tech forum for help. That said the error is fairly descriptive about the issue. You are comparing a non-aggregate...

Eric M Russell (2/9/2016)

---

...That's scary, though potentially not a problem. A number of states publish voter data as public records. A few might have restrictions on the use of that...

Eric M Russell (2/5/2016)

---

roger.plowman (2/5/2016)

---

Eric M Russell (2/3/2016)

---

As a DBA, if I get a 2am call that a critical application is down, because a select in a stored procedure is...

You can assign network logins to the specific application pools. Custom logins other than the defaults typically have little or no access on the local machine and can be...

jasona.work (2/4/2016)

---

So not as bad as I thought, but still a borderline idea.

Users of applications are authenticated via the application itself, so they have no direct access to SQL.

The way...

SeattleDBA (1/10/2016)

---

Alan.B (1/4/2016)

---

If the FTE salary for my area is $130,000 to $140,000 for a senior level DBA, that would be about $65 (W2) per hour based on 2,000 hours...

Eric M Russell (1/7/2016)

---

... I saw was of a press conference where the upper management of VW seems to indicate that the software developers on the project decided to alter...

Thanks Lynn - my JavaScript is apparently disabled in office....

The official documentation is here:

http://kb.winzip.com/kb/entry/125/

TomThomson (12/31/2015)

---

Matt Miller (#4) (12/22/2015)

---

The rite of passage concept is fairly diseased in my opinion, often used as a thinly veiled excuse for underpaying and abusing level entry workers, and...