Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.
SSMS Hangs with certain INSERT statement
I'm encountering a hanging SSMS when SQL Prompt tries to analyze this query in a query window:
INSERT INTO [ABC_ALL] SELECT * FROM [ABC_1] UNION ALL SELECT * FROM [ABC_2]
If I turn off Code Analysis (from the SQL Prompt menu) the problem doesn't happen.
If I turn Code Analysis on, and then click on the text, it freezes for a few seconds and then it's okay and I can click elsewhere. When I click again on the query, it hangs indefinitely (while chiding me for "INSERT without column list") (guilty).
It's a problem on SQL Prompt 18.104.22.16899 (also on 22.214.171.12421).
Microsoft SQL Server Management Studio 14.0.17285.0
Microsoft Analysis Services Client Tools 14.0.1016.283
Microsoft Data Access Components (MDAC) 10.0.17134.1
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.17134.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.3.17134
0 · Share on Twitter