I get this error "Protocol error in TDS Stream".

Hi
I have a table with following structure
Field1 VarChar(10)
Field2 VarChar(10)
Field3 Text
In this table there are 3000 records and for each record the Field3 contains
around 50000 to 60000 characters.
In SQL Query Analyzer, If I select all the records in the above table, I get
this error "Protocol error in TDS Stream". Can any one help me out to
resolve this error ?
Thanks,
SubbuThis is generally a bug in either SQL Server or the SQL Server ODBC Driver.
You should contact Product Support to report the problem.
Brannon Jones
Developer - MDAC
This posting is provided "as is" with no warranties and confers no rights.
"Subbu" <subbu@.chellasoft.nospam.com> wrote in message
news:OpAANsYwDHA.3496@.TK2MSFTNGP11.phx.gbl...

quote:

---

> Hi
> I have a table with following structure
> Field1 VarChar(10)
> Field2 VarChar(10)
> Field3 Text
> In this table there are 3000 records and for each record the Field3

---

contains

quote:

---

> around 50000 to 60000 characters.
> In SQL Query Analyzer, If I select all the records in the above table, I

---

get

quote:

---

> this error "Protocol error in TDS Stream". Can any one help me out to
> resolve this error ?
> Thanks,
> Subbu
>

---

I don't suppose BULK UPDATE exists?... like BULK INSERT?

I have to update a field within a table of 60 records or so. Each record has a different field value. it's type varchar. i was given an excel file with the field values and was thinking of a bulk update like bulk insert, but i don't recall that it's possible that way.

Is the only way to create a table, bulk insert, then merge the two tables together with UPDATE?

Just wanted to see if there was an easier way to do it, otherwise i'll take the latter route. Thanks!

You'll need to bulk insert into a work table, then do the update.

Unfortunately (or maybe, fortunately ) there's not Bulk Update.

Or, you could do the processing with SSIS....

I didn't drop the table

Hi, Andrea,
Thank you for your reply.
I didn't drop the table,and the records in the table seldom change.
Does it has anything to do with the weekly backup schedule? I remember I
once did something wrong and I had to restore the database.
Thanks for any relpy.
Long
hi,
Long wrote:
> Hi, Andrea,
> Thank you for your reply.
> I didn't drop the table,and the records in the table seldom change.
> Does it has anything to do with the weekly backup schedule? I
> remember I once did something wrong and I had to restore the database.
> Thanks for any relpy.
> Long
if you modified your database and data, restoring an older (unmodified)
version can produce such problems
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

I cant delete records

Hi,

My DB is MS SQL Server. I wrote a SQL statement to remove rows from a table as following.

DELETE FROM #TableA
FROM #TableA AS t1
LEFT JOIN #TableA AS t2 ON (t1.Index - 1) = t2.Index
WHERE t2.Index IS NULL

========================================

When I tried to execute it, I got the following error message.
Error Message: The table '#TableA' is ambiguous.

Thanks for your help.Interesting problem, never thought about it. I can imagine that MSSQL has some problem with guessing what to do.

I know it is not an answer to your question, the following syntax should do the same (if I got the query right) :

DELETE FROM #TableA
WHERE Index-1 NOT IN (SELECT Index FROM #TableA)

ps. Do you really have columns named "Index"|||You have answered my question.
Many Thanks.

I don't have a column named "Index", it is a alias to simply my question.

I am not sure whether I can use sql mobile.

Hi,

There are many text records need to be storeaged in my application.

I am new guy to Sql Mobile.

If I choose sql mobile to save my data. Will my app be more complex to deploy ?

Before I use Sql Mobile on device(wm5), need I install it first?

any other advice?

Best regards

PWang

SQL Mobile can store your textual data if your mobile application is constructed with Visual Studio 2005. You will have to include the SQL Mobile CAB files along with your application and install them on device in order to use this database engine. Yes, you have to install SQL Mobile on WM5 devices - it is not included in ROM.

You might want to read through some of the introductory information on the SQL Mobile Developer's Center on MSDN.

http://msdn.microsoft.com/sql/mobile/default.aspx

Darren

I am accessing data using data access pages in IIS 7 to SQL server 2005 Authentication is failin

is there a step by step paper to get there? here is what i need to consider. I Iwill have many customers that will need their own set of records and access pages "branded for their company" each customer will have many clients. I am hosting this application on a windows 2003 server with SQL 2005 server enterprise.

I am using windows authentication, I have created a username in windows, then i added the windows user in SQL management studio in security, granted "DB Read" and "DB write" and again under the database security tab. still from the web authentication fails. i must be nissing a step or two?

I expect to set up a username for each database as i setup new customers.

There is another post that had a similar issue...the discussion there may prove to be relevant for you:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=978330&SiteID=1

The important step is to disable Anonymous Authentication on your web server and enable Integrated Windows authentication. This will get the database request running in the context of the user making the web request (as opposed to the context of the default anonymous account).

Note that for data security/privacy reasons, you will probably want to avoid having clients from different companies, etc. sharing the same database and/or tables.

I am accessing data using data access pages in IIS 7 to SQL server 2005 Authentication is fa

is there a step by step paper to get there? here is what i need to consider. I Iwill have many customers that will need their own set of records and access pages "branded for their company" each customer will have many clients. I am hosting this application on a windows 2003 server with SQL 2005 server enterprise.

I am using windows authentication, I have created a username in windows, then i added the windows user in SQL management studio in security, granted "DB Read" and "DB write" and again under the database security tab. still from the web authentication fails. i must be nissing a step or two?

I expect to set up a username for each database as i setup new customers.

There is another post that had a similar issue...the discussion there may prove to be relevant for you:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=978330&SiteID=1

The important step is to disable Anonymous Authentication on your web server and enable Integrated Windows authentication. This will get the database request running in the context of the user making the web request (as opposed to the context of the default anonymous account).

Note that for data security/privacy reasons, you will probably want to avoid having clients from different companies, etc. sharing the same database and/or tables.