sql server - Select query produces SqlDateTime overflow on valid dates -

i have problem: on simple select select * table sqldatetime overflow error randomly returned (few times works ok after error returned; after again works few times , after error returned again) - error occurs on same row (while using same connection) - if open , close mgmt studio, error occurs on different row.

exact error message is:

an error occured while executing batch. error message is: sqldatetime overflow. must between 1/1/1753 12:00:00 , 12/31/9999 11:59:59 pm.

table has 3 datetime columns:

• dtcolumn1 - can null, without default value
• dtcolumn2 - must not null, default value ('1800-01-01')
• dtcolumn3 - can null, without default value

values in 3 datetime columns fine (null or inside of allowed interval).

table has other columns of varchar , other types. more select query fail more if add order 1 of 3 datetime columns (empiricaly tested).

collation of database slovenian_ci_ai.

what causing error (as said - datetime values seem ok)?

thank in advance!

edit 1 (2016-05-09): forgot mention previously: error happens in sql mgmt studio , code (using linq sql).

edit 2 (2016-05-10): seems there different problem - on every table more let's 10000 records throws silly error. on other table throws:

an error occurred while executing batch. error message is: internal connection fatal error.`

it disconnects me database (in bottom status row says disconnected). sql server installed on remote server inside of local network.

our admin found out, problem dne lightweight filter. if monster disabled works supposed (no random disconnects strange errors).

you can disable if go control panel / network , sharing center / change addapter settings. right click on network device , select properties. deselect dne lightweight filter.

link server fault, posted question when started believe network related problem.