• Were you able to find a resolution for this issue?

    We have multiple production servers, all on SQL Server 2014 latest SP and running ACE OLEDB 12.0

    Only on one of the servers, excel import queries get stuck once every 3-4 weeks. When this happens, I restart the service to make it work again.

    Killing the process results in a rollback that never completes. I have tried closing the connections using TCPView, that has not worked.

    Any pointer will help a great deal. Thanks.

    https://sqlroadie.com/