Error when copy/pasting code in SSMS using SQL Prompt 8.0.5.1758

HenrikM

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

FredericoJ

Hi @HenrikM,

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:

1. Let us know which versions of SQL Server instances you connect to?
2. Tell us what other SSMS extensions besides SQL Prompt have you installed in your system?
3. Enable verbose logging and send us the log file to sqlpromptteam@red-gate.com so we can check whether Prompt is doing anything at the time of the crash? The steps to do so are explained in this page.

Kind regards,

Frederico

HenrikM

Hi Frederico,

i have sent you an email with information you requested

Regards
Henrik

krzysztofkroczak

Thank you @HenrikM for mail.

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

HenrikM

Hi, no i do not have any other extensions installed on SSMS...
i am using SSMS through RDP, do not know if that can have an effect?

HenrikM

btw our server Collation is : Danish_Norwegian_CI_AS

Jessica R

Update: After working with @HenrikM through a support ticket, he has updated to the latest version of SQL Prompt (8.0.6.1890) and is no longer seeing the issue there.