sql prompt slowing ssms down when there is quoted code
kadeshara
Posts: 3
Hi there,
I've got a t-sql query (approx 500 lines) out of which there are 20ish lines that have quoted to build a dynamic sql.
Issue
Every time I try to edit/add the ssms comes to a stand still and it consumes 25% of pc cpu. The weirdest part is this only happens near the quoted code. e.g.
SELECT '"' CAST(round((Amount / Total_Amount) * Total_Amount,2) AS VARCHAR(10)) + '",' +
So I disabled SQL Prompt 5 (5.1.6.35) and ssms is working fine. Has anyone seen this before or is there a fix?
Thanks,
K
I've got a t-sql query (approx 500 lines) out of which there are 20ish lines that have quoted to build a dynamic sql.
Issue
Every time I try to edit/add the ssms comes to a stand still and it consumes 25% of pc cpu. The weirdest part is this only happens near the quoted code. e.g.
SELECT '"' CAST(round((Amount / Total_Amount) * Total_Amount,2) AS VARCHAR(10)) + '",' +
So I disabled SQL Prompt 5 (5.1.6.35) and ssms is working fine. Has anyone seen this before or is there a fix?
Thanks,
K
Comments
The query has 5 temp tables this made me wonder if http://www.red-gate.com/messageboard/vi ... hp?t=13660 is the cause, so I got a work colleague to try my query on a 5.1.4 version of SQL prompt. But still faced the same issue.
Redgate Software