November 28, 2017 at 3:05 pm
I'm having an issue in SSMS 2014 where I'm trying to debug a sql script and everytime I try to add a breakpoint ssms becomes unresponsive and won't add the breakpoint. I then have to close ssms via the task manager. Any recommendations on what could be the source problem?
November 29, 2017 at 12:53 am
Samwell - Tuesday, November 28, 2017 3:05 PMI'm having an issue in SSMS 2014 where I'm trying to debug a sql script and everytime I try to add a breakpoint ssms becomes unresponsive and won't add the breakpoint. I then have to close ssms via the task manager. Any recommendations on what could be the source problem?
Have you properly configured the debugger?
😎
November 29, 2017 at 12:40 pm
Samwell - Tuesday, November 28, 2017 3:05 PMI'm having an issue in SSMS 2014 where I'm trying to debug a sql script and everytime I try to add a breakpoint ssms becomes unresponsive and won't add the breakpoint. I then have to close ssms via the task manager. Any recommendations on what could be the source problem?
Are you debugging using this? :
Setting breakpoints in SSMS
Also have you tried turning off intellisense to see if that makes a difference with the unresponsiveness?
Sue
November 30, 2017 at 6:19 am
What references are available to determine if the debugger is properly configured?
November 30, 2017 at 6:29 am
I should add that I was running the debugger and setting breakpoints successfully and stepping through code and hour before this problem started. I received no error messages or indication of a problem until ssms started to freeze when setting a breakpoint.
December 1, 2017 at 7:05 am
It's possible that it just ran out of RAM. It's not real good at that. Just trying to copy and paste a sufficiently large result set can cause SSMS to crash.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
December 1, 2017 at 7:47 am
RAM was checked and I was only using about half.
December 1, 2017 at 8:03 am
Samwell - Friday, December 1, 2017 7:47 AMRAM was checked and I was only using about half.
That doesn't mean that SSMS had enough. It will only use so much, and if it needs more, you are out of luck. It's only a 32-bit program. If it were 64-bit, this would be a different conversation.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply