Time-lag of 1 hour in audit log

FAQ

Profile

Time-lag of 1 hour in audit log

Database Help (Home) -> Security

Next: What can Ruby do that PHP can not?

Author

Message

pher

External

Since: Jan 21, 2008
Posts: 7

(Msg. 1) Posted: Fri Dec 19, 2008 4:25 am Post subject: Time-lag of 1 hour in audit log Archived from groups: microsoft>public>sqlserver>security (more info?)

Hello I set up the audit log in SQL Server 2008. My problem is that I have a time-lag of 1 hour in the log, e.g. log date is 8 am for events occuring at 9 am. The system date and time are ok. Our timezone is set to GMT+1, is that the reason ? If yes, how can I set up SQL Server Audit to use the system time and not the UTC ? pher >> Stay informed about: Time-lag of 1 hour in audit log

Display posts from previous:

Related Topics:

Security Audit - I have problem with opening a SQL Server Logs. It takes over 5-10minutes to open the log file (Under Management->SQL Server Logs->Current). I have Audit level to log "ALL" due to SOX compliance. The errorlog files are about 19 megaby...

MSSQL audit and compliance tool - Hi Gurus, MSSQL servers are among the most commonly used servers. But we also know that MSSQL server security is a critical concern for most of the database administrators. This task will become handy with the help of Secure Auditor which is a unified..

Audit Fails for DOMAINAdministrator account on SQL server .. - Hi! I have a WSS 3.0 running on SQL Server 2005 Standard. It was upgraded from SQL Server 2005 Express edition. Everytime I restart server I have 4 events in the event log as follows: 1) SQL Database 'SharePoint_Config ' on SQL Server instance..

lastmodified - Hi, Can someone provide me a simple trigger where it updates a lastmodified column. It should update the column lastmodified whenever an update occurs on all the other columns. Thnx

sql agent service - I have SQL Server 2000 and I want to setup up SQL Server Agent as an automatic service, although I am not seeing it as an available service....how can I add the SQL Server Agent as a service?

	Database Help (Home) -> Security	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum