shri_sastry (2/5/2009)

---

yes it is just this one query, I am attaching the actual exec plan. When I run this in SSMS it is not so bad. but when I run...

You can create two user defined functions. One retrieves the names (after two dot) and one retrieves the group names.

Here is an example of user defined function. It can be...

Sorry about that.

I do not want to get to the details about our product. However, I was blamed when I said in our product we do not care about the...

The contents of Varchar(MAX), NVarchar(MAX), VarBinary(MAX), and XML fields are encoded using "Partially Length-Prefixed" (PLP in short). A PLP stream starts with total length (8 bytes), followed by current length...

Sorry about my mistake. I should not trust document from Microsoft 100%. Here is a sentence from "Tabular Data Stream Protocol Specification".

"A type with unlimited max size,...

Certainly, the error is related to your connection.

The problem can be one of the followings:

1. The connection to the server is broken (disconnected)

2. The packets...

First, you cannot have NVarchar(8000). Since varchar or NVarchar can only hold up to 8000 bytes, so the maximum length for NVarchar is 4000.

Second, NVarchar(MAX) and Varchar(MAX) can only...