Error: 0, Severity: 19, State: 0

While my production sql server was running, suddenly i got the error below and the connection was lost. Can anyone pls guide what is this error for, why this occured and how to resolve it. I got this error 2 times in two months.

Error: 0, Severity: 19, State: 0

SqlDumpExceptionHandler: Process 232 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

I run SQL Server 2000 with SP4 with OS Win 2003. I found this error in event viewer. I am assuming that some procedure was running at this time.

Pls help me in troubleshooting this issue.

Help appreciated.

You've hit a bug of some kind - an access violation is an unexpected condition. You need to contact Product Support (http://support.microsoft.com/sql) to help figure out what happened and whether there's a fix available.

Thanks

Error while processing a cube :(

I am getting the following error when trying to process my cube. Can someone
please guide as to how this problem can be solved. Thanks
Data source provider error: [Microsoft][ODBC SQL Server Driver][
SQL Server]Cannot resolve collation conflict for equal to operation.;37000;
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...When you process the cube you can see the query that olap is using to
retrieve data from SQL.
If you have a look at that query he is going to match several fields to each
other. In one of the fields you have a collation problem. You try to match
2 field together with a different collation.
You will have to check the collation settings of these fields.
Regards,
Nico
"Learner" wrote:

> I am getting the following error when trying to process my cube. Can someo
ne please guide as to how this problem can be solved. Thanks
> Data source provider error: [Microsoft][ODBC SQL Server Driver]
1;SQL Server]Cannot resolve collation conflict for equal to operation.;37000
;
> ****************************************
******************************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP & ASP.NE
T resources...
>|||Tons of thanks Nico.
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...