SQL Index corruption

[Merlyn MM]

I'm not a DBA to use the right words but I guess my sql index is corrupted, can anyone help me how to fix this problem? "coz sometimes its pulling the wrong record.

Thanks

[CF_Oracle]

Please be more specific: what database and what is your CF code and if possible what bdoes it mean "sometimes"?

[Merlyn MM]

wow..thank you for responding. I use MS Sql Server 8 and my CFcode deals with
sign up page and I'm using client variables when ever someone signs in they are
assigned client variables and storing them in the database. But they are
signing in with their username and password but they are getting different
person's account information. It only happened 3 or 4 times so far. I t
started from the past one month. I have no clue why. We use coldfusion 5.

[CF_Oracle]

It's hard to say what to do since 1) wrong autetified persons were
'successfullly' logged in means no error messages and errors logged on CF
server; 2)you don't know when it will happen again;3)it's probably on
production server where you can't experiment with debagger, cfdump etc. waiting
when it will happen again.
I could recommend:
- to analyze DB table that treat storing client variables (indexes and how
it's updated);
- to use in login page hash function for better autentification(see
[url]http://livedocs.macromedia.com/coldfusion/5.0/CFML_Reference/Functions105.htm#11[/url]
05551)