<div>
there may be various reasons why SQL Server took that much amount of time to delete such a small data <br />
<br />
The most probables one are listed below in the high to low probablity factor<br />
<br />
1) The table that you are deleted is locked by some other user<br />
2) An explict transasction is opened by an user in another SSMS window and left it open<br />
3) The Forieghn key constraint table has a huge data in the underlying tables probably millions<br />
4) the foreighn key constraint table is locked...
</div>


there may be various reasons why SQL Server took that much amount of time to delete such a small data

The most probables one are listed below in the high to low probablity factor

1) The table that you are deleted is locked by some other user
2) An explict transasction is opened by an user in another SSMS window and left it open
3) The Forieghn key constraint table has a huge data in the underlying tables probably millions
4) the foreighn key constraint table is locked...

<div>
Thank you Surendra. Is it possible to have sql stop executing if it exceeds certain timelimit?
</div>


Thank you Surendra. Is it possible to have sql stop executing if it exceeds certain timelimit?

<div>
<div class="content wysiwyg-content">
Hello,<br />
In SQL server manager I was deleting rows from a table. &nbsp;When I returned an hour later it was still executing even though the rows that should be deleted were only about 2000.<br />
While it was executing other calls to the database timed out, so that users could not login to my website. &nbsp;The reason may be that it could not delete a row because of foreign key.<br />
Why did it continue to execute and not stop? Can I change the sql settings so this does not happen again? I am using sql 2008.
</div>
</div>


Hello,
In SQL server manager I was deleting rows from a table.  When I returned an hour later it was still executing even though the rows that should be deleted were only about 2000.
While it was executing other calls to the database timed out, so that users could not login to my website.  The reason may be that it could not delete a row because of foreign key.
Why did it continue to execute and not stop? Can I change the sql settings so this does not happen again? I am using sql 2008.

sql executing timeout

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.