sql prompt slowing ssms down when there is quoted code

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

kadeshara July 10, 2011 22:05

Comments

2 comments

More details about the query..

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.

kadeshara July 11, 2011 21:56

0
Could you mail a full example script through to support@red-gate.com, quoting F0049931 in the subject line so we can test it here?

James B July 12, 2011 09:43

0

Add comment

Please sign in to leave a comment.

How can we help you today?

sql prompt slowing ssms down when there is quoted code

Comments

Add comment