Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Cancel debug query but it executes

Author  Topic 

thebrenda
Starting Member

22 Posts

Posted - 2013-09-03 : 16:25:53
I have a proc DeleteAllDatabases. I type 'exec DeleteAllDatabases' in a new query window and click Debug (green right arrow tip on debug toolbar). The debugger stops on the exec statement and i F11 into the proc. Before the first database is deleted i go back to the query window and click Cancel Query on the debug toolbar (red box). Message output says that the query was canceled. But my databases are deleted. What is up? Why did the query continue to execute


   

- Advertisement -