Daylight Savings Time Change in 2007

Is there a patch available for SQL Server 2000 to address the 2007 change in
daylight savings time?
Thank you very much in advance for your help.
Thanks,
Sally
Sally wrote:
> Is there a patch available for SQL Server 2000 to address the 2007 change in
> daylight savings time?
> Thank you very much in advance for your help.
> Thanks,
> Sally
SQL Server takes the current date and time from the OS. For details
see:
http://www.microsoft.com/windows/timezone/dst2007.mspx
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
sql

Daylight Savings Time Change in 2007

Is there a patch available for SQL Server 2000 to address the 2007 change in
daylight savings time?
Thank you very much in advance for your help.
Thanks,
SallySally wrote:
> Is there a patch available for SQL Server 2000 to address the 2007 change
in
> daylight savings time?
> Thank you very much in advance for your help.
> Thanks,
> Sally
SQL Server takes the current date and time from the OS. For details
see:
http://www.microsoft.com/windows/timezone/dst2007.mspx
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

Daylight Savings Patch for 2000 Server

I was wondering if there is a simple patch for 2000 server. It seems that the only fix is to edit the registry and to use the time zone editor app. If there is a simple patch like there is for the 2003 servers i would appreciate it if anyone can show me where. I have about 80+ servers with 2000!!!

Much appreciated!

Look at this KBA http://support.microsoft.com/?kbid=928388 for more information.|||

This is the actual kba for windows 2000 server: http://support.microsoft.com/kb/914387

As you can see, there's really no quick patch to run.

|||I don't understand. SQL Server has absolutely no clue what the time is, time zone, or anything else. It gets all of its timing information from Windows. So, if you fix the time in Windows, you are done. You aren't finding a patch, simply because there isn't one since there isn't anything in SQL Server to fix.|||If you are based in the USA then as per the KBA you need to patch as per the recent time zone settings.|||Which is precisely the point. You patch WINDOWS. You do NOT patch SQL Server, because there is no SQL Server patch for this.|||Michael, the original poster was trying to patch windows .... Windows Server 2000, not SQL 2000. Yes, not all of us are using Server 2003 on all our hardware.

So, I guess is it a manual patch for my Server 2000 machines? Any body found a better way?

Thanks,

Vidal|||

Hi Guys

I think I found a better way!!!

Tech Republic had an article (HTTP://articles.techrepublic.com.com/5100-10877-61680.htlm) that has a tool called TZEdit where you set the new times zone setting without having to hack the registry.

I installed it last night and it works , I'm deploying it to the rest of my Windows 2000 Servers today, just read the "help file" and make sure you go to control panel and unselect and reselect your time zone to have your changes take effect

Hope that helps ,Mike

Daylight Savings Patch for 2000 Server

I was wondering if there is a simple patch for 2000 server. It seems that the only fix is to edit the registry and to use the time zone editor app. If there is a simple patch like there is for the 2003 servers i would appreciate it if anyone can show me where. I have about 80+ servers with 2000!!!

Much appreciated!

Look at this KBA http://support.microsoft.com/?kbid=928388 for more information.|||

This is the actual kba for windows 2000 server: http://support.microsoft.com/kb/914387

As you can see, there's really no quick patch to run.

|||I don't understand. SQL Server has absolutely no clue what the time is, time zone, or anything else. It gets all of its timing information from Windows. So, if you fix the time in Windows, you are done. You aren't finding a patch, simply because there isn't one since there isn't anything in SQL Server to fix.|||If you are based in the USA then as per the KBA you need to patch as per the recent time zone settings.|||Which is precisely the point. You patch WINDOWS. You do NOT patch SQL Server, because there is no SQL Server patch for this.|||Michael, the original poster was trying to patch windows .... Windows Server 2000, not SQL 2000. Yes, not all of us are using Server 2003 on all our hardware.

So, I guess is it a manual patch for my Server 2000 machines? Any body found a better way?

Thanks,

Vidal|||

Hi Guys

I think I found a better way!!!

Tech Republic had an article (HTTP://articles.techrepublic.com.com/5100-10877-61680.htlm) that has a tool called TZEdit where you set the new times zone setting without having to hack the registry.

I installed it last night and it works , I'm deploying it to the rest of my Windows 2000 Servers today, just read the "help file" and make sure you go to control panel and unselect and reselect your time zone to have your changes take effect

Hope that helps ,Mike

daylight savings and MS SQL SERVER 2000

hello all
Is there a patch for MS SQL Server 2000 that addresses the upcoming daylight
savings change? And if so where can I find the download?
Thanks for the assistance.
Regards,
AndreThere are no changes to the SQL Server 2000 database engine. If you have
installed the separate Notification Services add-on, see
http://support.microsoft.com/kb/931815/en-us.
Hope this helps.
Dan Guzman
SQL Server MVP
"Andre Gibson" <AndreGibson@.discussions.microsoft.com> wrote in message
news:6402054C-305E-4B15-A92D-6AB630164BD7@.microsoft.com...
> hello all
> Is there a patch for MS SQL Server 2000 that addresses the upcoming
> daylight
> savings change? And if so where can I find the download?
> Thanks for the assistance.
> Regards,
> Andre|||This is probably what you are looking for:
How to prepare SQL Server 2005 and SQL Server 2000 for changes to daylight
saving time in 2007
http://support.microsoft.com/kb/931975/en-us
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Andre Gibson" <AndreGibson@.discussions.microsoft.com> wrote in message
news:6402054C-305E-4B15-A92D-6AB630164BD7@.microsoft.com...
> hello all
> Is there a patch for MS SQL Server 2000 that addresses the upcoming
> daylight
> savings change? And if so where can I find the download?
> Thanks for the assistance.
> Regards,
> Andre|||Thanks alot guys. I really appreciate the quick responses
regards,
Andre
"Andre Gibson" wrote:

> hello all
> Is there a patch for MS SQL Server 2000 that addresses the upcoming daylig
ht
> savings change? And if so where can I find the download?
> Thanks for the assistance.
> Regards,
> Andre