程式運行時 包錯:System.Web.Services.Protocols.SoapException: Server was unable to
process request. ---> System.Exception: Warning: Fatal error 9100 occurred at Nov
18 2019 2:36PM. Note the error and time, and contact your system administrator.,
SQLServer查詢分析器執行報錯 Fatal error 9100 occurred at Nov
18 2019 2:36PM. Note the error and time, and contact your system administrator.,
SQL中使用了Select distinct
問題原因是查詢中的某個表的索引存在問題,(修改索引會報錯)
將索引刪掉重建就OK了
使用排除法 減少查詢的字段,增加相關字段就報錯,減少就不報錯,差不多就是包含這個字段的索引存在問題