asked on

Change Server Timezone in SQL Server

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.

Raja Jegan R

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.

cntboys

ASKER

"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

Raja Jegan R

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.

cntboys

ASKER

Will these gaps still be apparent when users log back in if the change is odne out of hours?

ASKER CERTIFIED SOLUTION

Raja Jegan R

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial