I want to purposely corrupt a db for some testing. Any ideas on how this can
be accomplished?
SQL2K SP3
TIA, ChrisRhow about mashing up the mdf using Notepad as your editor?
"ChrisR" wrote:
> I want to purposely corrupt a db for some testing. Any ideas on how this c
an
> be accomplished?
> --
> SQL2K SP3
> TIA, ChrisR
>
>|||> I want to purposely corrupt a db for some testing. Any ideas on how this
> can
> be accomplished?
sp_configure allow, 1
go
reconfigure with override
go
update dbo.sysindexes set FirstIAM = 1234
where id = OBJECT_ID('YourTableName')
go
sp_configure allow, 0
go
reconfigure with override|||Perfect. Thanks.
"RADl0PASlV" <RADl0PASlV@.seznam.cz> wrote in message
news:en9sdjz9EHA.3592@.TK2MSFTNGP09.phx.gbl...
> sp_configure allow, 1
> go
> reconfigure with override
> go
> update dbo.sysindexes set FirstIAM = 1234
> where id = OBJECT_ID('YourTableName')
> go
> sp_configure allow, 0
> go
> reconfigure with override
>
No comments:
Post a Comment