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 cant understand how to perform file attachment to SQL2000

Hi!

i can't understand how to perform file attachment to SQL2000:

<connectionStrings>
<add name="SimpleListsConnectionString" connectionString="Data Source=local;AttachDbFilename=SimpleLists.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
</connectionStrings>

Server return error:

error 602: could not find row in sysindexes for database

run dbcc checktable on sysindexes

Can any body help?

Sorry its my mistake.

Remove question.

i can use SQL2005 Client Tools with SQL2000?

hi
i can use SQL2005 Client Tools (lik vs2005) with SQL2000, to control and run
SQL Statement?
--
Best Regards
Tark M. Siala
Development Manager
INTERNATIONAL COMPUTER CENTER (ICC.Networking)
Mobile: +218-91-3125900
E-Mail: tarksiala@.icc-libya.com
Messenger: tarksiala@.hotmail.com
Web Page: http://www.icc-libya.com
Blog: http://spaces.msn.com/tarksiala
======================================Absolutely have been for 18 months now
Simon Sabin
SQL Server MVP
http://sqljunkies.com/weblog/simons
"Tark Siala" <tarksiala@.icc-libya.com> wrote in message
news:utkx4v%23YGHA.4620@.TK2MSFTNGP04.phx.gbl...
> hi
> i can use SQL2005 Client Tools (lik vs2005) with SQL2000, to control and
> run SQL Statement?
> --
> Best Regards
> Tark M. Siala
> Development Manager
> INTERNATIONAL COMPUTER CENTER (ICC.Networking)
> Mobile: +218-91-3125900
> E-Mail: tarksiala@.icc-libya.com
> Messenger: tarksiala@.hotmail.com
> Web Page: http://www.icc-libya.com
> Blog: http://spaces.msn.com/tarksiala
> ======================================
>|||Definitely use Management Studio for all your databases, both SQL2005 and
SQL2000.
The only thing I think is a pain with it would be that when you generate the
script for an object, the drop statement isn't there. But it's not a
show-stopper, and you'll find that many of the features really help.
"Simon Sabin" wrote:

> Absolutely have been for 18 months now
> --
> Simon Sabin
> SQL Server MVP
> http://sqljunkies.com/weblog/simons
> "Tark Siala" <tarksiala@.icc-libya.com> wrote in message
> news:utkx4v%23YGHA.4620@.TK2MSFTNGP04.phx.gbl...
>
>|||Is there an automatic completion feature ?|||SoftLion wrote:
> Is there an automatic completion feature ?
>
Do you mean Intellisense? Not built-in, but SQL Prompt (free download)
will give you that capability. Works with the 2000 client tools as well.
http://www.red-gate.com/|||Is there an automatic completion feature ?|||SoftLion wrote:
> Is there an automatic completion feature ?
>
Do you mean Intellisense? Not built-in, but SQL Prompt (free download)
will give you that capability. Works with the 2000 client tools as well.
http://www.red-gate.com/

i can use SQL2005 Client Tools with SQL2000?

hi
i can use SQL2005 Client Tools (lik vs2005) with SQL2000, to control and run
SQL Statement?
--
Best Regards
Tark M. Siala
Development Manager
INTERNATIONAL COMPUTER CENTER (ICC.Networking)
Mobile: +218-91-3125900
E-Mail: tarksiala@.icc-libya.com
Messenger: tarksiala@.hotmail.com
Web Page: http://www.icc-libya.com
Blog: http://spaces.msn.com/tarksiala
======================================Absolutely have been for 18 months now
Simon Sabin
SQL Server MVP
http://sqljunkies.com/weblog/simons
"Tark Siala" <tarksiala@.icc-libya.com> wrote in message
news:utkx4v%23YGHA.4620@.TK2MSFTNGP04.phx.gbl...
> hi
> i can use SQL2005 Client Tools (lik vs2005) with SQL2000, to control and
> run SQL Statement?
> --
> Best Regards
> Tark M. Siala
> Development Manager
> INTERNATIONAL COMPUTER CENTER (ICC.Networking)
> Mobile: +218-91-3125900
> E-Mail: tarksiala@.icc-libya.com
> Messenger: tarksiala@.hotmail.com
> Web Page: http://www.icc-libya.com
> Blog: http://spaces.msn.com/tarksiala
> ======================================
>|||Definitely use Management Studio for all your databases, both SQL2005 and
SQL2000.
The only thing I think is a pain with it would be that when you generate the
script for an object, the drop statement isn't there. But it's not a
show-stopper, and you'll find that many of the features really help.
"Simon Sabin" wrote:

> Absolutely have been for 18 months now
> --
> Simon Sabin
> SQL Server MVP
> http://sqljunkies.com/weblog/simons
> "Tark Siala" <tarksiala@.icc-libya.com> wrote in message
> news:utkx4v%23YGHA.4620@.TK2MSFTNGP04.phx.gbl...
>
>|||Is there an automatic completion feature ?|||SoftLion wrote:
> Is there an automatic completion feature ?
>
Do you mean Intellisense? Not built-in, but SQL Prompt (free download)
will give you that capability. Works with the 2000 client tools as well.
http://www.red-gate.com/

HyperThreading with SQL Server 2000

Hi:

I have a server with 4 processors with hyperthreading, so my Windows Server 2003 Enterprise Edition see 8 processors. I have installed SQL Server 2000 Enterprise Edition and see 8 processors. The question is : if i install SQL Server 2000 Standard Edition, how many processors see and use 4 or 8 ?

I know that i have to license only 4 processors according to the Microsoft License, but,really, how many processors see and use?.sqlserver will see all logical processsors (i.e. 8) but you should limit the paralellism to only to 4 (physical) to avoid possible internal para blocking (i.e. max degree of paralellism).

Leaving HT on is a good thing but it's useless to allow all 8 schedulers to work on a single query.|||Why did you enable hyper-threading?

Even M$ admits that you probably are better off w/out it|||Because my server have this property by default then the operating system use this, i did think that use that was better for perfomance...i'm confuse. :confused:|||Rob is an MVP and does a lot of sql server work

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55887

Also, it's a lot of excess for a 10-20% (10 more likely) Perf gain...Plus you have a quad...I don't even think they list a quad

http://support.microsoft.com/default.aspx/kb/322385|||Please take a look at Kevin's article , Bare Metal Tuning (will require sqlmag sub to access the article).
http://www.windowsitpro.com/SQLServer/Article/ArticleID/46492/SQLServer_46492.html

In general, HT does give a boost in SQL perf (20-30% gain according to the TPC-C he and a Performance Engr from HP did). If you have an app that pushes L1/L2 cache heavily, turning off HT would only then be a good idea.

hyperlinks

Hi
I just upsized a database from Access to SQL everything seems to be working
fine except I had a Hyperlink field in Access which is not working with the
SQL tables and I see no data type in SQL for hyperlinks. Is there a way
around this?
Any help with the will be greatly appreciated
ChuckHyperlinks are only text, so a simple varchar datatype does it. SQL Server d
oesn't come with a
front-end development tool, which is where the interpretation of this text (
that it is an URL and
should be treated as such) takes place. I suggest you post this in a newsgro
up for the front-end dev
tool you are using.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Chuck216" <cigar216@.hotmail.com> wrote in message
news:ED93A6D4-11DB-43C0-ADEE-847722151619@.microsoft.com...
> Hi
> I just upsized a database from Access to SQL everything seems to be worki
ng
> fine except I had a Hyperlink field in Access which is not working with th
e
> SQL tables and I see no data type in SQL for hyperlinks. Is there a way
> around this?
>
> Any help with the will be greatly appreciated
> Chuck
>

hyperlink

Hi
I am trying to add a hyperlink to the table column so that it opens as an email ..that is
if user clicks onxyz@.X.com field the email should open with this addr in the to box.Any suggestions..
ThanksYou could use a template column:
<asp:TemplateColumn HeaderText="email" ItemStyle-Width="40" HeaderStyle-HorizontalAlign="center" ItemStyle-HorizontalAlign="center">
<ItemTemplate>
<a href="http://links.10026.com/?link=mailto:<%#DataBinder.Eval(Container.DataItem, "email").ToString()%>"><%#DataBinder.Eval(Container.DataItem, "email").ToString()%></a>
</ItemTemplate>
</asp:TemplateColumn>|||If you are trying to add hyperLink in SRServices then its very simple u can do that
In the layout mode click on the cell where to use MailTo and press F4 to open properties, go down and click on Action property and click...
and select Jump to URL radio button and in the text box write="mailto:" & Fields!Customer_Email.Value.
i think that is what u want
Thanks
Rohit