Lay Out SQL freezes SSMS

mihiesmihies Posts: 71 Bronze 4
edited July 26, 2008 8:39AM in SQL Refactor Previous Versions
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.
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
Blog:http://blog.rthand.com
Righthand .net consulting and software development
http://www.rthand.com

Comments

  • 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.
  • 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
    Jerry Hung
    DBA, MCITP
  • mihiesmihies Posts: 71 Bronze 4
    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.
    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]
    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.
    Miha Markic [MVP C#, INETA Country Leader for Slovenia]
    Blog:http://blog.rthand.com
    Righthand .net consulting and software development
    http://www.rthand.com
  • 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.
  • mglieneckemglienecke Posts: 1 Bronze 2
    Hello,

    I just wanted to mention that the suggested:

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

    does the job nicely :D 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
    Michael Glienecke
Sign In or Register to comment.