sqlclient

  1. J

    Windows 10 Convert DateTime is failing with following in Power Shell using SQLSERVER

    It tried to convert following time in Power Shell Script '2022-01-02T11:43:23.100Z' using Convert Function, and Cast. The tried same in SSMS and passed. Both SSMS and Power shell were connect to same instance of SQL Server 14.0.1000. Error message indicates in Power shell it is failing in...
  2. H

    Windows HPC fails to start after update (Server 2019)

    Hi all, When looking at the logs after the HPC console add-in fails to start I get the following (HPC scheduler): Exception: System.Data.SqlClient.SqlException (0x80131904): The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large...
    • hob63
    • Thread
    • availability connection datediff error exception hpc logs monitoring server 2019 sqlclient stack trace task scheduler update windows
    • Replies: 1
    • Forum: Windows Server Forums