I've been using SSMS, SQL Server Profiler and SQL Operations Studio for a while now without issue. However, when some query text (TextData column) was getting truncated in the profiler, I decide to increase the SSMS "XML Data" size to "5 MB". Now all three applications hang at different spots.
- SSMS and SOS hang when scripting table as a SELECT.
- SQL Profiler hangs after moving past the connection dialog.
In event viewer, I see this error:
Application: ioc.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: System.AccessViolationException
It's also important to note, it is definitely not the case that the trace window/connection dialog/etc. is rendering off screen. Simply, the applications are hanging due to an unhandled exception.
- Restoring Query Results options to default didn't work.
- Relaunching SSMS/SQL Server Profiler/Sql Operations Studio didn't work.
- Rebooting didn't work.
- Running applications as Administrator didn't work.