hi all!

can anybody help me to recover database

problem description :

error 7411 comes when server is started which results in failure of recovery of database(user database)

when i bypass the recovery and run dbcc tablealloc and checktable ...
it shows me corruption in systhresholds table, index id 1

exact message is :
keys of index id 1 for table 'systhresholds' in data page not in correct order.drop and re-create the index (index page 337)

help me with this....

thanx in advance
pooja

Some problems exist regarding your error. Can you please provide us the exact version of your ase ? select @@version output.

version is

Adaptive Server Enterprise/12.0/P/RS6000/AIX 4.3.2/1576/32bit/FBO/Thu Nov 4 09:40:01 1999