I'm asked to give training on dbcc commands. At present we do not have any
corrupted database.

Just wondering is there any way to simulate and retify the database
corruption.

Thanks
KRV

You can use 'dbcc corrupt' for this. This must be run in a database named
'victimdb' , e.g.:

use victimdb
go
dbcc corrupt (my_table, 0, 100002)
go


Note that dbcc corrupt is formally undocumented/unsupported.

HTH,

Rob V.
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5 / TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (new edition!)
"The Complete Sybase ASE Quick Reference Guide" (new edition!)
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:rob (AT) YOUR (DOT) SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

<KRV> wrote

Thanks for the quick help Rob,

Thanks
KRV

"Rob Verschoor" <rob (AT) DO (DOT) NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote in
message news:45866357 (AT) forums-1-dub (DOT) ..