Funny SQL Server Error Messages - anyone has an explanation?

I am getting a new server online at a customer, and our system shows very funny erorrs under full load. No explanations could be found. Anyone has some?

Here we go:

Server failed to resume the transaction, desc: 360000054a. The transaction active in this session has been committed or aborted by another session.,

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

and

New request is not allowed to start because it should come with valid transaction descriptor.

System.Data.SqlClient.SqlException

I am a little lost on those. Simple fact is that I do not find any description of those. Anyone an idea what causes these?

What's your SQL server version? It looks like a known issue with SQL2000. You can take a look at this article:http://support.microsoft.com/default.aspx?scid=kb;EN-US;834720#appliesto|||

2005, x64 version :-(

sql

FullText Ranking

Is there an article that explains how the fulltext results are ranked? I cannot find any good explanation. I only have found that 1000 is perfect match and 0 is worst possible match but what does that mean?

I mean how does something get a 1000 and how does something get a 0?

Thanks Again

Try this:

http://msdn2.microsoft.com/en-us/library/ms142524.aspx

|||

Thanks...

I was looking for something like that...