My WEB-server/MSSQL-server is in a different timezone (GMT -05:00). I need
to publish records restricted to "today" according to my timezone (GMT +
01.00).
How can I set up MSSQL/ASP/IISS to respond to a defined timezone?
(I know it is possible to use the dateadd-function, but this is not very
elegant - one would have to consider for the possibility of moving
applications to other hosts in other timezones and for daylight savings. )

Regards
Bjørn