I'm seeing lots of crash dump files generated (SQL Server 2012) due to this error:
Msg 596, Level 21, State 1, Line 0
Cannot continue the execution because the session is in the kill state.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
If I run the Select statement that is in that dump, I can reproduce the error in SSMS. When I comment a CONTAINS() filter in the WHERE clause the query runs without issue. And, when I run any query that uses the CONTAINS() function, a crash dump is generated.
How do I fix that CONTAINS() function? this is on a production server with many client databases and all databases are affected. I have a good system databases backup from a couple of days ago so would that reslove it? Not sure where CONTAINS() lives in the system databases.
Thanks in advance.