SQL server - switch to local time (do not use UTC)

I am developing a web project that uses ASP.NET, C#.
We use membership feature for user maintenance.
membership tables seem to store all UTC datetime.
Is there a switch or a property somewhere that will make SQL server to use local server time.

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.