if there are no rows present:

DBCC CHECKIDENT (yourtablename, RESEED, 0)

from the books online:

Basically it works like

Fill column1 with all you find till it hits the "," character

Fill column2 with all you find till it hits the "," character ...

So the last column...

if you put all 6 in a array, you can use a sorting algorithm to order them from low to high.

http://en.wikipedia.org/wiki/Sorting_algorithm

Average maximum=average of the 3 highest numbers, average minimum=average...

I work 38 hours a week with flexi-time. Life is more than work alone.

For sql server 2000 it is best to patch to service pack 3a or higher, this to fix many bugs.

By applying the service pack there is also a great chance...

@@Servername is not null?

Have you applied any sql server service packs?

wow 1.2 Million Seconds

Are all transactions properly committed before logging out? All locks are freed? All cursors are properly closed & deallocated?

Is this with each connection?

Adding the name & ip to the windows hosts file?

windows\system32\drivers\etc\hosts

do you have some sample records?

There could be a flaw in one of the indexes.

Have you tried dropping & rebuilding them?

A difference between SP3 & SP4 is that SP4 doesn't always convert the variable to the matching datatype of the table column and might choose to convert all rows to...

Hello,

If you have any questions about sql server, post them in the forums. The scope of your question is rather broad.

Error checking is quite limited in sql server 2000.Basically you...

Have you checked consistency of the database(s)?

Does it occur when a certain statement is started? (sql profiler is a help here)

indeed odd.

Found it works with binary collation for this selection.

select * from test order by [name]

COLLATE Latin1_General_BIN