Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SQL Server Time Settings

Author  Topic 

krisdotca
Starting Member

6 Posts

Posted - 2010-05-05 : 16:46:58
Hi There,

Are there time settings or time zone settings for SQL Server? I'm troubleshooting a problem with incorrect times in a SQL Server database and it looks to me like it might be related to an incorrect time setting but I'm not sure where to look.


Thanks, Kris

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-05 : 17:32:31
No, time and timezone is set at the OS level. We use GMT on our database servers to avoid timezone issues.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -