How to prepare SQL Server 2005 and SQL Server 2000 for changes to daylight saving time in 2007 http://support.microsoft.com/default.aspx?scid=kb;en-us;931975&sd=rss&spid=2855 Daylight Saving Time Help and Support Center http://support.microsoft.com/gp/cp_dst MohammedU. Moderator SQL-Server-Performance.com
In my experience Daylight Savings issues will come into picture only where there are complex jobs that are dependant on the time (like in SQL 4.2 & 6.5 days), but with latest versions of SQL Servers you can control such with a simple query. Appreciate your reference on tackling the issue though Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.