How to make aspnet DB use local time zone?

I created aspnet DB on SQL Server 2K using aspnet_regsql utility. Everything works fine except the DateTime fields in all tables are using a wrong time zone. How do I set it to use my local time zone?

Any help will be greatly appreciated.

All stored procedures in aspnetdb use UTC-based datetime fields. That's pretty normal practice for any database that might need to be accessed from multiple time zones.

How to know which tables is updated ?

is there way to know to which object is updated or in which tables record ha
s entered recently?
is there any utility in Sql Server 2000 or any kind of third party tool avai
lable ?
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.627 / Virus Database: 402 - Release Date: 03/16/2004You could use profiler to audit certain types of activity & subsequently see
what activity has occured through time.
You could use triggers &/or default values to maintain a list of who & when
records are added.
I generally add [Creator] & [CreationDate] fields with defaults of S
USER_SNAME() & GETDATE() respectively to any important tables...
--
James Goodman
MCSE MCDBA
http://www.angelfire.com/sports/f1pictures/
"Ashish Kanoongo" <ashishk@.armoursoftware.com> wrote in message news:%23xGOR
hBDEHA.3664@.TK2MSFTNGP10.phx.gbl...
is there way to know to which object is updated or in which tables record ha
s entered recently?
is there any utility in Sql Server 2000 or any kind of third party tool avai
lable ?
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.627 / Virus Database: 402 - Release Date: 03/16/2004|||You can also purchase Log Explorer from Lumigent (www.lumigent.com)... It ca
n read a log file and tell you the changes that were made...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's communi
ty of SQL Server professionals.
www.sqlpass.org
"Ashish Kanoongo" <ashishk@.armoursoftware.com> wrote in message news:%23xGOR
hBDEHA.3664@.TK2MSFTNGP10.phx.gbl...
is there way to know to which object is updated or in which tables record ha
s entered recently?
is there any utility in Sql Server 2000 or any kind of third party tool avai
lable ?
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.627 / Virus Database: 402 - Release Date: 03/16/2004