If your database was upgraded from 7.0 to 2000, read KB http://support.microsoft.com/default.aspx?scid=kb;en-us;298806&Product=sql

I would review server application/system logs for any possible errors which could cause the service restart.

In general, Access Violation in SQL Server indicates there are some bugs. For that, you should follow Steven suggestion, Call PSS.

Can you post of "select @@version" here? Any particular hoxfix are you aware of which has been applied to your SQL Server?

If the index is not clustered index, I would simple drop it and recreate it.

Edited by - allen_cui on 12/19/2003 5:53:56 PM