What are the challenges you face when working across database platforms? Take the survey
Options

sql prompt slowing ssms down when there is quoted code

kadesharakadeshara Posts: 3
edited July 12, 2011 9:43AM in SQL Prompt Previous Versions
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

Comments

Sign In or Register to comment.