Collation Errors

I have suddenly over night started getting Collation Errors?
I have neither changed anything or had any event to cause this. How has this occured and how do I rectify it?
Any help would be greatly appreciated.Any help would be greatly appreciated.

Could you please:

1. Include a sample error message
2. Include the DDL from a table on which you are getting an error message
3. Include the output from SELECT @.@.VERSION
4. Include the output from sp_configure

That may help troubleshoot the issue. But I make no promises.

Regards,

hmscott

CodeGen.net

hi, i cant use codeGen.net with SQL SERVER 6.5 this cause SQl SERVER 6.5 dose not support sqlclient is there is way to connect SQL SERVER 6.5. thanxYou can still use OleDb (System.Data.OleDb) to connect SQL 6.5

CMEMTHREAD

CMEMTHREAD is displayed as a last wait type. This specific SPID is a cause of blocking.
What does CMEMTHREAD mean?
http://sqldev.net/misc/WaitTypes.htm
Andrew J. Kelly SQL MVP
"Alan" <Alan@.discussions.microsoft.com> wrote in message
news:77CDDCCA-7716-4C8C-9C23-3615DE1AED89@.microsoft.com...
> CMEMTHREAD is displayed as a last wait type. This specific SPID is a
cause of blocking.
> What does CMEMTHREAD mean?
>

CMEMTHREAD

CMEMTHREAD is displayed as a last wait type. This specific SPID is a cause
of blocking.
What does CMEMTHREAD mean?http://sqldev.net/misc/WaitTypes.htm
Andrew J. Kelly SQL MVP
"Alan" <Alan@.discussions.microsoft.com> wrote in message
news:77CDDCCA-7716-4C8C-9C23-3615DE1AED89@.microsoft.com...
> CMEMTHREAD is displayed as a last wait type. This specific SPID is a
cause of blocking.
> What does CMEMTHREAD mean?
>

CMEMTHREAD

CMEMTHREAD is displayed as a last wait type. This specific SPID is a cause of blocking.
What does CMEMTHREAD mean?http://sqldev.net/misc/WaitTypes.htm
--
Andrew J. Kelly SQL MVP
"Alan" <Alan@.discussions.microsoft.com> wrote in message
news:77CDDCCA-7716-4C8C-9C23-3615DE1AED89@.microsoft.com...
> CMEMTHREAD is displayed as a last wait type. This specific SPID is a
cause of blocking.
> What does CMEMTHREAD mean?
>