SQL Server Audit (timestamp) not correct

Last Post 18 Oct 2013 05:57 AM by rm. 5 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ctseah
New Member
New Member

--
10 Oct 2013 02:20 AM
Hi,

When I looked at the audit information of the sql server, the timestamp is not correct.
Does anybody know where have gone wrong. I am on sql 2008 sp3.

Thanks in advance.

regards
rm
New Member
New Member

--
10 Oct 2013 05:57 AM
Is system clock correct? Set to correct time zone?
ctseah
New Member
New Member

--
14 Oct 2013 02:34 AM
System clock is correct.
Time zone also correctly set.

Wonder why when I view the audit log file through the studio management, it is not showing the time correctly ?

thanks
regards
rm
New Member
New Member

--
14 Oct 2013 06:13 AM
Maybe it's UTC time?
ctseah
New Member
New Member

--
17 Oct 2013 08:25 PM
Hi ,

Yes indeed it is showing UTC time.
Thanks for pointing that out.

May I know is there a way for it to show time and date according to my timezone ?

Thanks in advance.

regards
rm
New Member
New Member

--
18 Oct 2013 05:57 AM
Not as I know of.
You are not authorized to post a reply.

Acceptable Use Policy