About how to crash the database

Hi Guy,
I am testing an application and want to crash the database. Is there a way
to crash the database when database is runing? Thanks.SQL Server 2000 -
Update or Delete some rows from YourDatabase..sysindexes and that should do
the trick
If you choose the update method, try to update the FirstIAM column to random
numbers.
If you're running 2005, you may find it more difficult and may want to use a
hex editor on the raw database files to cause some damage.
BE WARNED!!!! - Do this at your own risk and do not run on a live
server/database!!!
Immy
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:08EAA006-0763-4B38-B057-1317C33C654D@.microsoft.com...
> Hi Guy,
> I am testing an application and want to crash the database. Is there a way
> to crash the database when database is runing? Thanks.
>|||You could have SQL Server restrict access to the database as follows:
ALTER DATABASE Yourdb
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
GO
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Just pull drives out of the server until you get an error. ;-)
Iter wrote:
> Hi Guy,
> I am testing an application and want to crash the database. Is there a way
> to crash the database when database is runing? Thanks.
>