Home All Groups Group Topic Archive Search About

how to crash/corrupt a Microsoft SQL 2005 Server?



Author
16 Mar 2006 4:27 PM
zot
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....

Author
16 Mar 2006 4:33 PM
SQL
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/
Are all your drivers up to date? click for free checkup

Author
16 Mar 2006 4:47 PM
zot
an infinite loop, i see.
should I run this overnight? lol

Bookmark and Share