| Author |
Topic |
|
kavish82
Starting Member
5 Posts |
 Posted - 2009-07-13 : 03:37:35
|
| i have a database server on which the time displayed for my logins in my dbo audit file is 4 hrs behind that displayed on my pc. I.e: if the time displayed on my pc is 10am, the time displayed on the dbo file is 6am. can you help me to solve this out. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-13 : 04:33:30
|
| Yes, change your servers regional settings (windows) to be in the same timezone as yourself. If the server does not belong to you, there is not a lot you can do though. |
 |
|
|
kavish82
Starting Member
5 Posts |
Posted - 2009-07-13 : 06:25:07
|
| the server's regional setting is ok, but only on the dbo.audit file i'm having these problems. do u think something related to the following script may change something:CREATE TABLE AuditEntry ( ActionDate datetime NOT NULL, UserName nvarchar(64) NOT NULL, ComputerName nvarchar(64) NOT NULL, Application nvarchar(64) NOT NULL, Action nvarchar(64) NOT NULL, ObjectName nvarchar(64), Information nvarchar(1500), Severity int NOT NULL, VideoDestination int, VideoDestinationType int, ActionId int, SourceIp int, SequenceId int ); |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-13 : 06:39:39
|
| No, because that is just a table structure with its data-types. If thsi problem ios only in one place, perhaps you have a default on your date column or the trigger (I am guessing that is what you are using for your auditing), has a strange bit of code in it that tried to add some time to a datetime.Please look at what writes to this table and I think you will have your answer. |
|
|
|
kavish82
Starting Member
5 Posts |
Posted - 2009-07-13 : 07:42:54
|
| if u have am email address i can sed u the snapshots..?? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-13 : 08:01:21
|
| No sorry, I only answer questions on here, I do not answer personal emails. If you have the scripts, either look in them yourself or post them here. If it is not the scripts (trigger/sproc etc), then please explain properly how data is inserted into this table. |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-07-13 : 15:41:17
|
| It is possible for the servers regional setting to be correct while the time is incorrect. Especially on windows 2000 boxes that people hack-jobbed when DST Changed. |
|
|
|
kavish82
Starting Member
5 Posts |
Posted - 2009-07-14 : 03:22:54
|
| here is the script:CREATE TABLE AuditEntry ( ActionDate datetime NOT NULL, UserName nvarchar(64) NOT NULL, ComputerName nvarchar(64) NOT NULL, Application nvarchar(64) NOT NULL, Action nvarchar(64) NOT NULL, ObjectName nvarchar(64), Information nvarchar(1500), Severity int NOT NULL, VideoDestination int, VideoDestinationType int, ActionId int, SourceIp int, SequenceId int ); |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-14 : 04:20:22
|
| Yeah, you posted that. That is the table structure and doesn't tell us a lot. Can you check the date on the server is correct?As said, how does this table get written to? Please run the following and post the code for all procedures and/or triggers where there is an insert or update into AuditEntry.Go to the database, right click and go to All Tasks -> Generate SQL Scripts... Generate all objects and search for AuditEntry. |
|
|
|
|
changing timezone