0
I’m trying to delete lines from an SQL Express database, but unfortunately I can’t do it. The query is one of those really basic, but after running it I get the message from 'executing query' in SQL Server Management Studio indefinitely, but never ends.
The query is the following:
DELETE FROM table_name
WHERE condition;
6
You need to see if you have other sessions in management studio with pending operations blocking delete. Try clicking on the icon Activity Monitor or Ctrl + Alt + To and see the Processes tab, and see who’s blocking you
Browser other questions tagged sql sql-server
You are not signed in. Login or sign up in order to post.
Does the table have a trigger? Or is it being used by another process?
– Jefferson Quesado
You need to see if you have any other sessions in management studio with pending operations blocking delete. Try clicking on the "Activity Monitor" icon (Ctrl+Alt+A) and see the Processes tab, and you’ll see who’s blocking you
– Renato Afonso
I don’t know what’s trigger, can give me a light?
– ihavenokia
@Renatoafonso were pending operations that were delaying the execution of the query, thanks for the suggestion, unaware of the 'Activity Monitor', mt top!
– ihavenokia
Always at the orders... :) Ps: mark as answered
– Renato Afonso
@Renatoafonso so que possa marque como responder you have transform your comment in response.
– Reginaldo Rigo
@ihavenokia Trigger
– Jefferson Quesado