F-word with three consecutive U-letters! SQL Management Studio just crashed, just when I had finished a nice script, that I hadn't of course saved yet. I must say SQL Management Studio hardly ever crashes, can't even remember the last time that happened before this. Wonder if it has anything to do with the plugin SQL Complete that I installed just recently? SQL Complete also has the annoying habit of displaying a popup every time SQL Management Studio is started, with a delay just long enough so you have already got started with something when you're interrupted by that popup. No, I'm not going to upgrade a piece of software that behaves maliciously!

@IllSlapU You are unathorized to tell me what to say. I'm not censoring myself, I just find this way of expressing myself more fun and sophisticated than just going around blurting out prophanities and telling other ranters you hate them.

@IllSlapU
Well some people are not comfortable saying it .so let's focus on the problem .😕

I managed to reproduce the problem. The crash occurs when I try to do an "Edit top 200" on a table. It does that every time now. Uninstalling SQL Complete didn't help, but at least now I get a better error message than just "SQL Management Studio has stopped working". Now it says: "Exception has been thrown by the target of an invocation. (mscorlib)". with the additional information that "Attempted to read or write protected memory. This is often an indication that other memory is corrupt. (Microsoft.VisualStudio.OLE.Interop).". Hmmm, next thing I'm going to try is to restart the computer and if the problem persists, reinstall SQL Management Studio. I'm a bit annoyed now.

@TerriToniAX it might be the size of the database that you working with , sometimes the memory in your machine won't handle huge data but it always depends on the software (IDE) that you use so check the size if the problem persists🤔

Anyway, the upside of this story is that it only took matter of minutes to rewrite the script I lost. This is quite typical for coding, most of the time is spent on the thinking that goes into it. Once you've figured it out, it doesn't take long to (re)type.

@bendee I have plenty of free memory, but it might very well be too segmented. Somehow, I had come to believe that Windows 7 was capable of desegmenting memory. Well, I'll reboot now and then let's see if it gets any better.

Yep, works now.

@TerriToniAX No, it doesn't! SELECT TOP 1000 works. But EDIT TOP 200 doesn't. WTF!

I think that SQL Complete has broken my SQL Management Studio. SQL Complete seemed so nice, but it is from hell!

@TerriToniAX 🤔🤔🤔

@TerriToniAX well try uninstalling the studio and reinstall it again it might help.

@TerriToniAX There's been an update on the server, which might cause the problem. Repairing the client doesn't help, but an update for Visual Studio might. A colleague has the same problem, but then again, he also uses SQL Complete so it's too early to rule out as the culprit.

@TerriToniAX The VS Update didn't help.

It turns out that SQL Complete isn't the culprit after all. My apologies to Devart (the makers of SQL Complete). I take back the bad things I said about it - except the thing about the popups at startup, they still annoy the crap out of me. Apart from that, SQL Complete is an excellent utility and almost as addictive as Tetris ;) So I've reinstalled it and am once again enjoying its marvels :DDD

@TerriToniAX *LOL* Just as I praised SQL Complete, it stopped working. Maybe it's angry with me for first having condemned it to hell ;)