Lay Out SQL freezes SSMS

mihies

Hi guys,

Is there any fix to SSMS freeze when Lay Out SQL is invoked. It constantly freezes SSMS in my case - I have to take it down through Task Manager afterwards. I am using latest versions for both SSMS and SQL Refactor.

Ben Pinchen

Is it only the Layout SQL functionality that hangs SSMS? Have you tried any of the other SQL Refactor options to see if they exhibit the same behaviour?

We've had a handful of customers that have experienced hanging in SQL Refactor. It seems that some of the SQL Refactor problems were caused by improper installations of Management Studio. In particular, something had removed the registration from one of the extensibility components called TextMgrP.dll.

Could you try opening a command prompt and running regsvr32 "%commonprogramfiles%\microsoft Shared\MSEnv\TextMgrP.dll"

If this doesn't seem to resolve the issue then the other way that some customers have resolved this is to reinstall SSMS and SQL Refactor.

jerryhung

Unfortunately I have never had SQL Refactor working 100% (it freezes my SSMS more than I liked)

but then comes SQL Prompt 3.8 which has built-in layout function, and I am a happy camper ever since, and it works well with the SSMS Tools Pack as well

mihies

Ben Pinchen wrote:

Is it only the Layout SQL functionality that hangs SSMS? Have you tried any of the other SQL Refactor options to see if they exhibit the same behaviour?

Yes, all SSMS related operations freeze SSMS. Others, unrelated (i.e Options..., check for update, ...), work.

Ben Pinchen wrote:

We've had a handful of customers that have experienced hanging in SQL Refactor. It seems that some of the SQL Refactor problems were caused by improper installations of Management Studio. In particular, something had removed the registration from one of the extensibility components called TextMgrP.dll.

Could you try opening a command prompt and running regsvr32 "%commonprogramfiles%\microsoft Shared\MSEnv\TextMgrP.dll"

Yields an error:
[Window Title]
RegSvr32

[Content]
The module "C:\Program Files\Common Files\microsoft shared\MSEnv\TextMgrP.dll" was loaded but the call to DllRegisterServer failed with error code 0x80070005.

For more information about this problem, search online using the error code as a search term.

[OK]

Ben Pinchen wrote:

If this doesn't seem to resolve the issue then the other way that some customers have resolved this is to reinstall SSMS and SQL Refactor.

Yep, reinstalling everything worked. For time being SQL Refactor is working normally again.

Ben Pinchen

Thanks for letting me know. I'm glad that it's resolved your issue and I'm sorry that you had to reinstall everything to get it working again.

mglienecke

Hello,

I just wanted to mention that the suggested:

regsvr32 "%commonprogramfiles%\microsofthared\MSEnv\TextMgrP.dll"

does the job nicely and now everything is back to normal (no more frozen SSMS). I assume it had something to do with me installing VS 2008 on my box which brought the change to SSMS

All the best