June 7, 2018 at 1:46 am
Hello,
Is there a possibility to find from T-SQL when the Regional Settings and the Date changed on the server?
The internal server date was set in the past.
Also can I change the internal server date from SQL straight?
Have select current_timestamp for example at (now + 3 days).
Thank you!
June 11, 2018 at 4:06 pm
ralu_k_17 - Thursday, June 7, 2018 1:46 AMHello,Is there a possibility to find from T-SQL when the Regional Settings and the Date changed on the server?
The internal server date was set in the past.Also can I change the internal server date from SQL straight?
Have select current_timestamp for example at (now + 3 days).Thank you!
The change of the settings might be in the event logs - the International log under Applications and Services\Microsoft\Windows does log some of that. I don't think there is anything inside SQL Server to search this directly other than shelling out to the OS and using something like wevtutil from the command line.
Same for date settings. I'm not aware of anything in SQL Server to do this directly other than again going to the OS with xp_cmdshell and executing date to set the date. You could have policies that prevent changing date and time.
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply