Solved

DBCC Corrupt

Posted on 2001-07-19
1
901 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

A look at what happened in the Verizon cloud breach.
Let's recap what we learned from yesterday's Skyport Systems webinar.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

630 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