>What is the best way to retrieve the db server's date/time?
>
>I'm sure there's a fancier/better way to do it than:
>
>

>select getdate() from sometable where pk=knowngoodpk
>

Simple select getdate() as ServerTime should work too. - no need to use a table.