SQL Server Logs

• Gary Cobden

  Ten Centuries

  Points: 1269

  More actions

  October 30, 2007 at 8:21 am

  #73788

  The date of my SQL Server Logs are showing in US Date format eg 2007-30-10 12:50, whereas the dates of the individual entries within the logs is showing correctly as 2007-10-30 12:50.

  Any ideas how this may be corrected so that the Log Summaries show the correct date formats

  Thanks

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  November 2, 2007 at 12:12 am

  #747626

  You need to cahnge either your sql server or windows server collation.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com