DELETE in SQL does not execute

0

I'm trying to delete rows from a SQL Express database, but unfortunately I can not do it. The query is one of those same basic ones, but once I run it I get the ' executing query' message in SQL Server Management Studio indefinitely, but it never ends.

The query is as follows:

DELETE FROM table_name 
WHERE condition;
    
asked by anonymous 25.09.2017 / 12:18

1 answer

6

You have to see if you have other sessions in management studio with pending operations blocking delete. Try clicking on the Activity Monitor or Ctrl + Alt + A icon and see the Processes tab and see who is blocking you p>     

25.09.2017 / 13:45