No problem. I just meant that my issue was resolved.
Thanks, Roger A. Nall Manager, OSSNMS Remedy T-Mobile USA Desk: 813-348-2556(New) Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer Sent: Monday, March 12, 2007 4:59 PM To: [email protected] Subject: Re: DST Test Results on March 11th 8:00 AM ** Hi Roger .... I removed RESOLVED because although your issue was taken care others may have open issues. Hope that was ok, Susan On 3/12/07, Nall, Roger <[EMAIL PROTECTED]> wrote: After applying this patch, http://support.microsoft.com/kb/932590 , all is well. Thanks to everyone for their suggestions. Regards, Roger A. Nall Manager, OSSNMS Remedy T-Mobile USA Desk: 813-348-2556(New) Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Monday, March 12, 2007 9:21 AM To: [email protected] Subject: Re: DST Test Results on March 11th 8:00 AM Another, or additional, method would be to run a Direct SQL command each time users login (loads the main form) UPDATE AR_System_User_Preference SET Time_Zone = NULL WHERE Submitter = '$USER$' This would take effect the next time the user logged in. I actually do this with a stored procedure that sets a number of settings in the preference form. Users are allowed to change some settings in the User Tool but there are some that I want every user to have. This has completely eliminated support calls for fixing User Tool settings. You could also simply Null out the field for all users at once using a tool such as SQL Query Analyzer. UPDATE AR_System_User_Preference SET Time_Zone = NULL HTH Stephen ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
