Yup...I see this error message: "Length specified in network packet payload did not match number of bytes read; the connection has been closed. " which can correspond to something messing...

It is a SQL Server 2008 Enterprise SP2 server.

jared-709193 (10/3/2011)

---

Also, SQL Server will return the error you are getting if even 1 row returns an invalid argument for the substring. So, if one of your strings does...

Lowell (10/3/2011)

---

does this return the expected data?

SELECT

id,

SUBSTRING(CONVERT(VARCHAR(max), Data),

CHARINDEX('<t2>', CONVERT(VARCHAR(max), Data)) + 4,

( CHARINDEX('</t2>', CONVERT(VARCHAR(max), Data))...

jared-709193 (10/3/2011)

---

DBAgal (10/3/2011)

---

MyDoggieJessie (10/3/2011)

---

I don't believe the length of it matters. I used your code and made up a string of nearly 6400 characters and it still ran...

MyDoggieJessie (10/3/2011)

---

I don't believe the length of it matters. I used your code and made up a string of nearly 6400 characters and it still ran just fine...

Either...

MyDoggieJessie (10/3/2011)

---

I checked your code and ran something similar on SQL 2000/2005/and 2008 servers and it worked perfectly. Please run the code below on your system to see if...

SELECT id,

SUBSTRING(Data, CHARINDEX('<t2>', Data)+4, (CHARINDEX('</t2>', Data)- CHARINDEX('<t2>', Data))-4)

FROM Tablename

String Example:

sdfjksdhfksdhkfhsdkfhksdhfksdhfksdhf<t2>net.rim.blackberry</t2><t3>1</t3><t4>sadfsfsdfdsf</t4><t5>asdasdasdsa</t5><t6>7.0.0</t6><t7>asdasdasdsa</t7><t8>asdasdasdas</t8><t9>asdasdasd;</t9></R>

Should return: net.rim.blackberry

Instead getting, "Invalid length...

JeremyE (9/28/2011)

---

Keep the witness in the same site as your principal database. If the principal loses connection with both the witness and the mirror the principal database will become unavailable....

JeremyE (9/28/2011)

---

Yuri55 (9/28/2011)

---

Jeremy,

Sorry, but frankly I confused with your recommendation "Keep the witness in the same site as your principal database"

(and certainly I know that per BOL MS "We strongly...

JeremyE (9/28/2011)

---

Keep the witness in the same site as your principal database. If the principal loses connection with both the witness and the mirror the principal database will become unavailable....

I need them to check to see if some files are available before the rest of the package runs....

sturner (9/9/2011)

---

try using a try - catch scenario. That is, do the update statistics in the try and in the catch detect the 1205 error and retry if it indicates...

OP - I've noticed the same thing recently. Honestly, I think some of the more knowledgeable DBAs just stay away for the SQL Server 2008 General forum, because questions...

"2.The principal server writes the transaction to the database and, concurrently, sends the log record to the mirror server. The principal server waits for an acknowledgement from the mirror server...