How to corrupt a db

• 5409045121009-7368

  SSCoach

  Points: 15740

  More actions

  June 12, 2003 at 3:26 pm

  #461155

  Spongemagnet, the term code injection spring to mind plus add the code from MarkusB!

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  June 13, 2003 at 12:24 am

  #461201

  Hi BrandonGalderisi,

  quote:

  ---

  This didn't work for me.... any suggestions?

  ---

  it seems to work only on SQL7, not SQL2k. Something's changed with FirstIAM?

  Cheers,

  Frank

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  June 13, 2003 at 1:11 am

  #461209

  I ran it on SQL2K it it did work for me. Although the database seemed to be ok in EM, as soon as you run a SELECT on the table in question you get an error.

  By the way DBCC CHECKALLOC can fix the database again.

  [font="Verdana"]Markus Bohse[/font]

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  June 13, 2003 at 1:15 am

  #461210

  Hi MarkusB,

  quote:

  ---

  I ran it on SQL2K it it did work for me. Although the database seemed to be ok in EM, as soon as you run a SELECT on the table in question you get an error.

  By the way DBCC CHECKALLOC can fix the database again.

  ---

  I'll try again. Thanks for anticipating the answer to the not yet asked follow-up question.

  Cheers,

  Frank

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• shew

  SSChampion

  Points: 11389

  More actions

  June 23, 2003 at 8:12 am

  #462624

  Here is something that works for me on SQL 6.5 and 2000 (I didn't test it with 7.0):

  Jon

  -----------------------

  use TestCorrupt

  go

  /*******************************************************************************

  *

  *Create a test table

  *

  ********************************************************+**********************/

  create table junk

  (

  col1int,

  col2char(1),

  col3varchar(50),

  col4datetime

  )

  create index Junk_IDX1 on Junk

  (col1)

  go

  /*******************************************************************************

  *

  *Allow updates to the system tables

  *

  ********************************************************+**********************/

  sp_configure 'allow updates', 1

  go

  reconfigure with override

  go

  /*******************************************************************************

  *

  *Make an orphan out of the index by deleting the table which it

  *references

  *

  ********************************************************+**********************/

  select * from sysobjects where name = 'junk'

  delete from sysobjects where name = 'junk'

  go

  /*******************************************************************************

  *

  *Disallow updates to the system tables

  *

  ********************************************************+**********************/

  sp_configure 'allow updates', 0

  go

  reconfigure with override

  go

  /*******************************************************************************

  *

  *Display the corruption

  *

  ********************************************************+**********************/

  dbcc checkcatalog(TestCorrupt)

  go