create corruption

sql2k sp3a
Is there a way for me to create db corruption to do some testing?
TIA, ChrisManually delete a row from sysindexes (but don't delete anything with id <
100).
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"ChrisR" <noemail@.bla.com> wrote in message
news:%23WgmjHulFHA.3316@.TK2MSFTNGP14.phx.gbl...
> sql2k sp3a
> Is there a way for me to create db corruption to do some testing?
> TIA, Chris
>|||Thanks Randal, but this doesn't return an error, which is really what I
need. (@.@.Error still = 0) Heres what I'm trying to do.
alter procedure admin_DBCCCheckDB
as
declare @.Exec varchar(256)
declare @.Error int
declare @.rc int
declare @.ServerName varchar(256)
declare @.DBName varchar(128)
declare @.Subject varchar(128)
set @.ServerName = (select @.@.ServerName)
set @.DBName = (select db_name())
SET @.Exec = 'dbcc checkdb(''' + @.DBName + ''')' + 'WITH NO_INFOMSGS'
set @.Subject = 'Database corruption in the ' +@.DBName+ ' database!!!'
EXEC (@.Exec)
SELECT @.Error = @.@.error
print @.Error
IF @.Error <> 0
exec @.rc = master.dbo.xp_smtp_sendmail
@.FROM = @.ServerName
,@.TO = 'SQLAdmins@.Bla.com'
,@.Subject = @.Subject
,@.server = N'255.255.255.255'
,@.Port = 25
"Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
news:usgrpPulFHA.3828@.TK2MSFTNGP12.phx.gbl...
> Manually delete a row from sysindexes (but don't delete anything with id <
> 100).
> --
> Paul Randal
> Dev Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "ChrisR" <noemail@.bla.com> wrote in message
> news:%23WgmjHulFHA.3316@.TK2MSFTNGP14.phx.gbl...
>