Sometimes logging onto a box for a simple change like this is not possible for the business. This allows you to change this directly from T-SQL without having to log on or RDP into the box.
--Check Curent Windows Time Zone select GETUTCDATE() --Check Current Local Time Zone select getdate() --Change Time Zone to Mountain Time EXEC XP_CMDSHELL 'RunDLL32.exe shell32.dll,Control_RunDLL timedate.cpl,,/Z (GMT-07:00) Mountain Time' --Verify Windows Time Zone select GETUTCDATE() --Verify Local Time Zone Change select getdate()
In this article by Steve Jones, he shows you how to manipulate strings.
2004-04-05
17,565 reads
My ASP file doesn’t access my database." "I can’t connect to my database from my code." "I’m having problems calling and debugging stored procedures." These are some of the problems I hear every day as a Microsoft® developer support engineer.
2001-07-20
2,008 reads
If you’re a programmer, you know that SQL is becoming more and more prevalent. Here’s a guide to one of its basic building blocks the stored procedure.
2001-07-09
4,417 reads
XP_FILEEXIST gives you the ability to find files and directories. Find out how else you can use it in this article.
2001-06-08
19,310 reads
In part one of a two part article, Andy Warren challenges the readers of SQLServerCentral.com to solve a problem involving ADO and SQL Server. Are you up to the challenge?
2001-06-01
4,182 reads
