I have a strange problem - when I am querying SQL table with more than 9000 rows, SQL randomly disconnects with some unrelated error.
1.) What I mean with randomly disconnects: On average it happens approximately on every fourth or fifth query (but not necessary). If I order by some date it is more likely for query to fail, if no order is applied it is less likely for query to fail. In SQL MGMT Studio in the bottom toolbar disconnect icon appears, only few rows are returned (but not all). If I query table with less than 9000 rows or if I limit number of returned rows (with TOP, for example) query doesn't fail.
2.) What I mean with unrelated error:
An error occurred while executing batch. Error message is: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
An error occurred while executing batch. Error message is: Internal connection fatal error.
Data is fine (dates are inside the allowed interval). Queries fail not only from SQL MGMT Studio but also from code. In SQL Profiler everything looks fine. SQL server runs on different server inside of a local network, DEV server (from which I execute the queries) is virtualized on my PC (also inside of the same local network).
My coworkers, who are connected to the same database from their own machines are not having any problems.
We are suspecting that something network related on my machine is the problem, but cannot find it.
Thank you in advance!