Microsoft distributes Microsoft SQL Server 2008 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 fix release.
Consider the following scenario:
- You have a table that has a spatial data type column in Microsoft SQL Server 2008.
- An index for the spatial data type column exists.
- A query references the spatial data type column in the workload that is used by Database Tuning Advisor (DTA).
<Date> <Time> spid# SqlDumpExceptionHandler: Process# generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Service pack information for SQL Server 2008To resolve this issue, obtain the latest service pack for SQL Server 2008. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
968382 How to obtain the latest service pack for SQL Server 2008
To work around this issue, use one of the following methods:
- Disable or drop the spatial index on the spatial data type column and rebuild the index after the DTA analysis is finished.
- Remove the query that references the spatial data type columns and that references the spatial data type indexes in the workload that is used by DTA.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Article ID: 2588453 - Last Review: Aug 22, 2011 - Revision: 1