Groups | Blog | Home
all groups > sql server programming > january 2005 >

sql server programming : sql server automatic update error



oj
1/21/2005 9:41:23 PM
The only way to know is to turn on tracing/audit. See book online for detail
on how to create a server trace.

--
-oj


[quoted text, click to view]

kerstink
1/21/2005 10:51:39 PM
Hi:

I have a download form.

On completion the information is saved into the database and a unique
username and unique password created, additionally I save the datetime for
when they form was submitted.

From there they go to a login page. On login (checks for the unique username
and unique password) the database gets updated on a different datetime field
for tracking the last time they logged in and I increment a counter by 1 to
track for how often they log in.

This is running for a year now and we encountered no error initially.

About 5 month back I encountered the first time this error.

Suddenly all counters where incremented by 2 or 3 times and all the last
accessed fields date reset to the night before. Then all the new entries are
good.

About 1 month later this happened again.

What could cause this?

Thanks, Kerstin

AddThis Social Bookmark Button