Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MuadDBA
628 Posts |
 Posted - 2003-04-07 : 13:42:39
|
| I am trying to build a clustered index on a pretty large table.I have enough space in my tempdb to handle quite a bit of sorting, and room in the DB to expand if necessary, but for some reason I keep getting this error when I try to build the index:SqlDumpExceptionHandler: Process 9 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.What is this? Can someone help me firgure out how to get the index built? I had it built on the original DB (this is a migration), and now we're moving to a new server and so I cleaned up a lot of the data, fixed some DBCC errors, and tried to build this index, and blorp, I get this error every time. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-07 : 13:49:41
|
| There are lots of reasons why access violations occur, so you will need to check MS' knowledge base for the reason why yours is failing (support.microsoft.com). Just typing in EXCEPTION_ACCESS_VIOLATION returns lots of records. Most likely you are getting the message because of a bug. What server pack are you on (also what version of SQL Server)?Tara |
 |
|
|
|
|
|
Access Violation when building clustered index?