SQL Refactor Hangs in SSMS, sometimes. Why?
jerryhung
Posts: 138
My SQL Refactor hangs/froze in my SSMS, sometimes, not always
SQL Refactor version 1.1.0.102
I also have SQL Prompt 3.6.0.109 installed
Have SQL 2005 SP2 installed on my machine (SSMS 9.00.3042.00)
Code:
Action:
Outcome:
It either stays at 0%, or 99%, SOMETIMES
Normally if I killed SqlWb.exe and re-try again, it works next time
In comparison, I loved SQL Prompt much more than SQL Refactor
SQL Refactor version 1.1.0.102
I also have SQL Prompt 3.6.0.109 installed
Have SQL 2005 SP2 installed on my machine (SSMS 9.00.3042.00)
Code:
select top 100
a.backup_finish_date,
case a.[type] when 'D' then 'Database' when 'L' then 'Trans Log' end as backuptype,
a.server_name,
a.database_name,
a.recovery_model,
b.physical_device_name
from msdb.dbo.backupset a
left join msdb.dbo.backupmediafamily b
on a.media_set_id = b.media_set_id
order by a.backup_finish_date desc
Action:
-
Selected section of code
Under SQL Refactor, select Uppercase Keyword, or Layout SQL
Outcome:
It either stays at 0%, or 99%, SOMETIMES
Normally if I killed SqlWb.exe and re-try again, it works next time
In comparison, I loved SQL Prompt much more than SQL Refactor
Jerry Hung
DBA, MCITP
DBA, MCITP
Comments
I think the problem occured since I have patched SQL Promt.
Cheers
I have had to kill & restart SSMS like 5~10 times in a day, IF I use SQL Refactor; otherwise SSMS + SQL Prompt can last me all day long
DBA, MCITP
At least if I disable it and press CTRL+L it won't crash.
I am going to open a support ticket with them as well, hopefully that will speed things up.
Cheers
I had the exact same problem on my computer with these settings:
Vista 32, SSMS 9, SQL refactor 1.1.0.102, SQL Prompt 3.6.0.109
Even CTRL-B, CTRL-U (uppercasing) on a completely empty window in a freshly opened SSMS, made SSMS freeze forever.
It started this behaviour yesterday and I havent installed anything [just] before, so I simply made a windows-recovery, rolling it back two days. After reboot, opening SSMS told me "configuring for first time use", and then everything worked perfectly again.
Im holding my breath and crossing my fingers next time windows automatically updates....
I've tested this even with a very small database (1 table with 3 columns) using just a "select * from X" query and it never works.
I'm quite disappointed at the moment. Any pointers?
Are you using any third party tools within Management Studio?
Our support team have identified from past experiences that for most of these hang situations disabling/removing those tools fix the issue.
Thanks,
Tanya
DBA, MCITP
so my SSMS still doesn't like the combination of SSMS Tools and SQL Refactor.
Today alone I had 2 encounters where SQL Refactor hangs at 0% but doesn't kill the SSMS yet. I know if I run Ctrl-B, Ctrl-L again after that, it'll freeze SSMS for sure
I will uninstall SSMS Tools for this week and observe more
It's unfortunately if they cannot coexist, as SSMS Tools has some neat features such as "Generate Insert Statement", create CRUD code, etc..
DBA, MCITP
You can upgrade by 'checking for updates' in a previous version of SQL Refactor or it can be downloaded from
http://www.red-gate.com/products/SQL_Refactor/index.htm
EventType : clr20r3 P1 : sqlwb.exe P2 : 2005.90.3042.0 P3 : 45cd69e0
P4 : redgate.refactoring.addin P5 : 1.3.0.207 P6 : 48873bb8 P7 : 610
P8 : 20 P9 : system.invalidcastexception
I too am a contractor, and I'd used this for ages before beginning to experience an issue back in February. There's no chance I'd be allowed to reinstall SSMS, so if there isn't some other fix for this I'll just have to remove SQL Refactor.
regsvr32 "%commonprogramfiles%\microsoft shared\msenv\textmgrp.dll"
as advised in the following forum topic:
https://apps2.red-gate.com/MessageBoard/viewtopic.php?t=7094