Home » Posts tagged "corruption"

Duplicate rows in sysusers??

SAP Adaptive Server Enterprise

If you’re like me, you’ve run into lots of different issues with the Sybase ASE DBMS over the years. Today, Drew Montgomery looked at what happens when the 12.5.x -> 12.5.4 upgrade goes bad: If you receive the 8419 error on sysusers after applying ASE...

Continue reading »

Finding suspect indexes in Sybase ASE

SAP Adaptive Server Enterprise

Problem: ASE does not use an index on a table because it is marked suspect Index id 2 on table id 864003078 cannot be used in the optimization of a query as it is SUSPECT. Please have the SA run DBCC REINDEX on the specified...

Continue reading »

Facebook login by WP-FB-AutoConnect