I am using SQL server 2008. Now I need to change the time zone in DB sever as per the country. Con anyone answer me the following queries.
1. How to change the time zone in DB server.
2. Do I need to chnge the timing setting in windows also in that server?
3. I have multiple instances for different zone in that server. Can I set the time for each instance as per the local time of that zone?
Thanks in advance.
//All our dreams can come true, if we have the courage to pursue them//