Multiple Databases on Single Server with Independent Dates

mjopatrny

I have the following situation:

> Server running Microsoft Server 2003 and SQL Server 2005
> NAV 5.0 SP1 SQL Option
> Four databases - each in a different time zone
> Users will access NAV through RDP or an IPSEC client (no Citrix)

What I would like to do is have each database post transactions using a local date instead of the server date. A coworker mentioned that I could set the WORK DATE when the user logs into the database. I can do this, but the WORK DATE gets reset when the server date changes. Additionally, are there any triggers that execute to check the WORK DATE against the Server's time?

Any feedback is greatly appreciated.

kine

There is nothing like that, but there are ways how to get the server name. Just use the search and look for "Server time" or something like that. Than you can check it when you want.