> I run SQL Server 2000 on shared server.
> When I work from my office location then everyting is ok, every query
> completes fine.
> Today, I stayed home, opened query analyzer and types simple query
>
> select * from Mytable where myid = 5034
>
> This worked fine.
> Next, I added order by
>
> select * from Mytable where myid = 5034 order by myprimarykeyid
>
> I got this error message
> [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream
> [Microsoft][ODBC SQL Server Driver]Function sequence error
>
>
> Next, I changed order by to some other field
>
> select * from Mytable where myid = 5034 order by myforeignkeyid
>
> This worked fine. Anyways, every time I try to run this query with order
> by on primary key field, I get
> [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream
> [Microsoft][ODBC SQL Server Driver]Function sequence error
>
>
> Any idea?