SSMS SQL Server Management Studio, close automatically when executed Larze size query in Query Window.
It donot give any warning, just close all the opened query window, even it will not ask you to save the open Query Window
I traces the Error from Events: see below:
Faulting application name: Ssms.exe, version: 2011.110.2100.60, time stamp: 0x4f35e2d9
Faulting module name: Microsoft.SqlServer.Management.SqlParser.ni.dll, version: 11.0.2100.60, time stamp: 0x4f35e255
Exception code: 0xc00000fd
Fault offset:
Faulting process id:
Faulting application start time: 0x01d7771d1009d970
Faulting application path: C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe
Faulting module path: C:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.S1e156a8e#\7884276fc39356973c434ef7a131480a\Microsoft.SqlServer.Management.SqlParser.ni.dll
What the Query is?
So Query is select statement contains 25000 union all with single column, with no syntax error
How i Resolve the Issue:
My main motive is to insert records in table using Union ALL
And i converted query into Individual Insert statement with Select CTAS
And it works for me.
i read somewhere on internet, Intellisense is causing the problem of crashing
