how to crash/corrupt a Microsoft SQL 2005 Server?

hello everyone,
I'm doing some big load testing on my SQL 2005 Server like
adding/update/remove thousands of entries. I wonder what would cause my
server to crash or data corruption? It seems to run fine on load
testing...well run this to start things off
declare @.id int
select @.id =1
while @.id < 100
begin
select getdate(),newid()
--select @.id = @.id + 1 --oops commented out by mistake
end
http://sqlservercode.blogspot.com/|||an infinite loop, i see.
should I run this overnight? lol

how to crash/corrupt a Microsoft SQL 2005 Server?

hello everyone,
I'm doing some big load testing on my SQL 2005 Server like
adding/update/remove thousands of entries. I wonder what would cause my
server to crash or data corruption? It seems to run fine on load
testing...
well run this to start things off
declare @.id int
select @.id =1
while @.id < 100
begin
select getdate(),newid()
--select @.id = @.id + 1 --oops commented out by mistake
end
http://sqlservercode.blogspot.com/
|||an infinite loop, i see.
should I run this overnight? lol

how to crash/corrupt a Microsoft SQL 2005 Server?

hello everyone,
I'm doing some big load testing on my SQL 2005 Server like
adding/update/remove thousands of entries. I wonder what would cause my
server to crash or data corruption? It seems to run fine on load
testing...well run this to start things off
declare @.id int
select @.id =1
while @.id < 100
begin
select getdate(),newid()
--select @.id = @.id + 1 --oops commented out by mistake
end
http://sqlservercode.blogspot.com/|||an infinite loop, i see.
should I run this overnight? lol

How to corrupt data

Hello!
I'm intresed in all possible ways to corrupt data and log files in SQL Server 2000 except manually editing them.
Thank you in advance.you can hurt peaple more directly if that what you want|||Damn!

I'm not intrested in hurting anyone!
On the opposite - I work in QA team for the company that makes disaster recovery software for various databases. I need this information in order to test our product.|||So what you are really saying is that you need help doing your job.|||Correct! And I'm not ashamed of it. This is not a kind of information you can find in books or manuals.

how to corrupt a db

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 can
> 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...
> > 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
>

how to corrupt a db

I want to purposely corrupt a db for some testing. Any ideas on how this can
be accomplished?
SQL2K SP3
TIA, ChrisR
how 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 can
> 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
>

how to corrupt a db

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
>