Solved

DBCC Corrupt

Posted on 2001-07-19
1
884 Views
Last Modified: 2011-09-20
Anybody know the procedure to use DBCC corrupt, to forcibly corrupt a database table
0
Comment
Question by:amathur347
1 Comment
 
LVL 10

Accepted Solution

by:
bret earned 100 total points
ID: 6300749
Sure.  First off, it will only run against a database named "victimdb".

You then call dbcc corrupt with an object (id or name),  index id, and error number

Example:

dbcc corrupt(mytable, 1, 2540)

will cause a 2540 error on the clustered index of mytable.

There is a quite limited set of errors that this command can create, mostly errors
that TABLEALLOC will fix:  1133, 2502, 2503, 2521, 2523,2525, 2529, 2540, 2546, and 7939.

It is also not documented or supported in any way by Sybase (so if it fails to corrupt your
table, Sybase won't fix it so it does  :-)

-bret
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
When we talk about DevOps toolchains, I sometimes wonder how many people really get what we’re talking about. I don’t know if it’s just semantics or tone or something else, but sometimes I think it just sounds like buzzword sausage. So it’s always …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now