Settings in SQL Server 2000 1

[RonRepp]

Hi all:

Is there a setting somewhere in SQL Server 2000 that forces client-side sorting.

Any help will be greatly appreciated.



Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.

 

[mrdenny]

No. Sorting can be done server side via the ORDER BY clause. If you want to do the sorting client side you'll have to write something into the client to handle the sorting.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[RonRepp]

It wasn't the answer I wanted, but thanks.



Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.

 

[mrdenny]

no problem

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com