Hi,

when i create a new user in a .MDF file, the hour of creation in the field
"createdate" of table "membership" is exactly 2 hours less than the time of
my computer. Probably something to do with different hours between Europe
and UK or ...

How can i set the creation hour to exact the same hour of my computer?

Thanks
Dan

Hello,

The creation date will be always based on the date time on the SQL Server
machine.

Thanks
Hari

"Dan" <danperrt (AT) nomaol (DOT) nl> wrote

But when the clock of my computer is 10am and i create an user at that
moment, the creation date will be 8am.
Is it possible to change the date time of sql server into the real date time
of the internal clock of my computer?

"Hari Prasad" <hari_prasad_k (AT) hotmail (DOT) com> schreef in bericht
news:eeVX2IbgHHA.4064 (AT) TK2MSFTNGP03 (DOT) phx.gbl...