Solved

Change Server Timezone in SQL Server

Posted on 2009-07-08
5
1,879 Views
Last Modified: 2012-05-07
Hi

I would like to know if anyone has any experience with changing the server timezone on a sql box, the user has SQL server 2005 installed on a Server box which is currently set to a US time zone, he would like to know of any problems with changing the time zone to BST regarding the SQL database.
0
Comment
Question by:cntboys
  • 3
  • 2
5 Comments
 
LVL 57

Expert Comment

by:Raja Jegan R
Comment Utility
There is nothing like SQL Server Timezone.

All timezones are referred from your Server OS timezones.
Hence in your Regional Settings, change the timezone from US to BST and this should work fine.

You might feel some gaps for some of the records during this time change.
Hence it is best adviced to perform this activity in your maintenance window.
0
 

Author Comment

by:cntboys
Comment Utility
"You might feel some gaps for some of the records during this time change"

Thanks for your reply, but can you clarify the above part of it
0
 
LVL 57

Expert Comment

by:Raja Jegan R
Comment Utility
For eg: Assume if your current timezone is -5:30 and you are moving to GMT ie., 0:00.
Then current time of 20:30 will be corrected out there as 04:00 am the next day. Hence you feel gaps between these values.

Suppose if you run a query that finds difference between two records across these values, then you might find that as odd and I meant that one as gaps.

Hope this clarifies.
0
 

Author Comment

by:cntboys
Comment Utility
Will these gaps still be apparent when users log back in if the change is odne out of hours?
0
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 500 total points
Comment Utility
>> Will these gaps still be apparent when users log back in if the change is odne out of hours?

If you do it in a live machine these gaps will be apparent.
But if it is done in a known maintenance window, you can be sure that its a maintenance window in case you debug to find the cause of it.

Kindly analyze in your application whether any queries check for difference in hours / minutes so that you can be sure whether your system is impacted or not. If you dont have any queries like that, then you need not worry about that.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now