Check event viewer for more info
The SQL Server (MSSQLSERVER) service terminated unexpectedly. It has done this 1 time(s).
Example of query i ran
SELECT fname , lname
--ssn
from oraclelinkedserver.dbname.dbo.table
Cause
This issue occurs because the special characters "--" exist in the query to the Oracle linked server. These characters are used as a comment symbol.
The SQL Server process crashes because of the third-party linked server provider which is loaded inside SQL Server process. If the third-party linked server provider is enabled together with the Allow inprocess option, the SQL Server process crashes when this third-party linked server experiences internal problems.
Workaround
To workaround this issue, use one of the following methods:
Remove the comments symbol, or
Replace the comments symbol with the following comments symbol:
/* */
this works;
SELECT fname , lname
from oraclelinkedserver.dbname.dbo.table
