Error when copy/pasting code in SSMS using SQL Prompt 8.0.5.1758
HenrikM
Posts: 7 Bronze 1
in SQL Prompt
Hi,
when copy pasting SQL code in a tab in SSMS, SSMS crashes. Have been able to reproduce the error in SSMS versions 2012, 2016 and 17.1.
If SQL Prompt is disabled (Enable suggestions is not marked) or the tab is not connected to a SQL server instance, the copy paste works fine.
The error also did not occurs in SSMS 2012 using SQL Prompt 7.x.x.x (cannot remember the specific version 7 number)
The SQL code that has the problem is attached (extension renamed to .txt from .sql)
The copy operation was from (start marked by |Start|
WHEN NOT MATCHED BY TARGET THEN
INSERT ( |Start|[JOBID]
to (end marked by |End|)
[DW_ID_Audit_Update]|End|
)
VALUES ( [JOBID] ,
and it is not necessary to paste the code before the crash in SSMS occurs
the error info returned by SSMS is :
Problem signature:
Problem Event Name: APPCRASH
Application Name: Ssms.exe
Application Version: 2011.110.6020.0
Application Timestamp: 5626c8d2
Fault Module Name: StackHash_199c
Fault Module Version: 0.0.0.0
Fault Module Timestamp: 00000000
Exception Code: c00000fd
Exception Offset: 10658625
OS Version: 6.1.7601.2.1.0.18.10
Locale ID: 1030
Additional Information 1: 199c
Additional Information 2: 199cc907df8a4654c8ebf31545ec3b64
Additional Information 3: ac93
Additional Information 4: ac932fb721b478be6e53cf5b63cba0e7
when copy pasting SQL code in a tab in SSMS, SSMS crashes. Have been able to reproduce the error in SSMS versions 2012, 2016 and 17.1.
If SQL Prompt is disabled (Enable suggestions is not marked) or the tab is not connected to a SQL server instance, the copy paste works fine.
The error also did not occurs in SSMS 2012 using SQL Prompt 7.x.x.x (cannot remember the specific version 7 number)
The SQL code that has the problem is attached (extension renamed to .txt from .sql)
The copy operation was from (start marked by |Start|
WHEN NOT MATCHED BY TARGET THEN
INSERT ( |Start|[JOBID]
to (end marked by |End|)
[DW_ID_Audit_Update]|End|
)
VALUES ( [JOBID] ,
and it is not necessary to paste the code before the crash in SSMS occurs
the error info returned by SSMS is :
Problem signature:
Problem Event Name: APPCRASH
Application Name: Ssms.exe
Application Version: 2011.110.6020.0
Application Timestamp: 5626c8d2
Fault Module Name: StackHash_199c
Fault Module Version: 0.0.0.0
Fault Module Timestamp: 00000000
Exception Code: c00000fd
Exception Offset: 10658625
OS Version: 6.1.7601.2.1.0.18.10
Locale ID: 1030
Additional Information 1: 199c
Additional Information 2: 199cc907df8a4654c8ebf31545ec3b64
Additional Information 3: ac93
Additional Information 4: ac932fb721b478be6e53cf5b63cba0e7
Tagged:
Comments
I'm sorry to hear you are seeing crashes in SSMS. Unfortunately, we haven't been able to replicate this behaviour on our end.
To help us track this down, can you please:
Kind regards,
Frederico
Redgate Software
i have sent you an email with information you requested
Regards
Henrik
Unfortunately, we still can't replicate the problem. We tested it with @FredericoJ on all types of SSMS which you mentioned with prompt. The logs, which you sent to us, didn't show any errors or warnings.
So do you have any other extensions for SSMS?
Kind regards,
Krzysztof
i am using SSMS through RDP, do not know if that can have an effect?
Jessica Ramos | Product Support Engineer | Redgate Software
Have you visited our Help Center?