Time



Is it possible to set the server clock using SQL. I have full admin rights
to the SQL server, but not to the windows 2000 OS.

Problem I have is that the clock is 6 mins fast, and I am struggling to find
an administrator each time the clock "slips"


.



Relevant Pages

  • Re: Windows clock
    ... I will look up the Automachron program for her so she can ... keep updated if something happens with the server clock. ... >Windows way. ...
    (microsoft.public.win2000.file_system)
  • Re: getutcdate() issues
    ... Why not give Sql Server its own internal clock? ... MSSQLSERVER service and syncs 1x/day to a inet timeserver which you must ... them with the correct system clock. ...
    (microsoft.public.sqlserver.programming)
  • Re: php code, timezones affecting mysql?
    ... because I can directly access it and see the entries there. ... Some entries are missing, just displaying ... server clock, the PHP server clock, and the clock on the ...
    (comp.lang.php)
  • Re: getdate() problem: where is the time taken from ?
    ... which has it's own clock. ... getdate() does not always reflect you recently updated system time. ... Assuming that SQL Server reads the system clock every 3.33 ms, ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: php code, timezones affecting mysql?
    ... because I can directly access it and see the entries there. ... You've got potentially three different clocks here: The MySQL ... server clock, the PHP server clock, and the clock on the ...
    (comp.lang.php)

Loading