The Access Violation error is triggered when an execution plan with parallelism involves specific system table functions. We found that the error occurs ONLY with parallel execution plans.
Therefore, in order to reproduce it, you’ll need:
– SQL Server instance with MaxDOP setting not equal to 1
– At least 2 available CPU cores
Click through for additional details, including a script to generate the same error yourself.