Posted by Neil on 11/29/07 13:46

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns99F6EF225864CYazorman@127.0.0.1...
> Neil (nospam@nospam.net) writes:
>> I'm using an Access MDB as a front end to a SQL 7 database. When I place
>> the system time in a field in Access, it used the user's clock. I'd like
>> to use the SQL Server system time, so that the times will be
>> synchronized. I suppose I can just do a pass-through query with "select
>> getdate()." But I was wondering if there was some built-in method,
>> either in Access or SQL Server. I'm concerned about the overhead of
>> running a pass-through query every time I need the current time.
>
> It you want the time on the server, "SELECT getdate()" is probably the
> simplest way to do it. But you could of course make a remote procedure
> call outside SQL Server as a little exercise in Windows programming
> if you like. I can't see that's worth the pain, though.
>

:-) Thanks! Just wanted to make sure I wasn't missing something.

[Back to original message]