How can I get the user's local time zone and not the servers time zone?
If I have a user in California and the server location is in New York,
I want to retrieve both the time zones within Sql Server but seem to can only retrieve the server - Eastern time zone.
I can have users in PST, MST and CST time zones, but I need their time zone to get real time stamp data for auditing
Sql Server 2008