Tim,

Take a look at Re: Trying to find source for SqlProfileProvider.cs file Thread #1309118 Message #1309585

Bonnie asked similar question in .NET forum as well few months back, I'll search.

>Hi All,
>
>I have a web application that is connected to a SQL Server database. This SQL Sever is located in Texas and thus is Central Time. I have a C# application that is saving data to the SQL Server via a WCF application. This application saves a row with a DateTime field that indicates the time the record was created on the application. It is created with a DateTime.Now in C# at the application level. This application is running on a computer in Pacific time and the computer time is set to pacific time. The time in the SQL server is being saved in central time.
>
>I am assuming there is something in the SQL Server that is changing this time when saved. How do I override this behavior when I save the record? I want the times to be saved the way I created them.
>Thanks
>Tim