Change current date/time on SQL server machine

  • Hi all,

    One customer changed windows date/time while SQL server was running and some applications were connected to it (and uses the GetDate function), then the whole system hanged. (Don't whether one process was using 100% CPU or whether the system was no longer responding because it happened on customer's site).

    Is this unrecommended to change date/time under those conditions ?

    Has anyone experienced something similar ?

    Thanks for your help.

    Patrick

     

    Patrick Duflot

  • If you observe daylight savings time then that is basically the same action the system takes on behalf of itself. I have not seen any issues specifically like this unless there is something in your design such as running jobs that could have been triggered to run at an unexpected point.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply