SQL Prompt Hanging

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

SQL Prompt Hanging

Postby jase74 » Mon Jun 13, 2011 4:26 pm

I'm using SQL Server Management Studio and everytime use the Uppercase Keywords menu item from prompt, it hangs Management Studio.
jase74
 
Posts: 4
Joined: Wed May 16, 2007 10:56 am

Postby jase74 » Mon Jun 13, 2011 5:01 pm

Some additional info

    SQL Prompt 5.1.4.11
    Management Studio 10.50.1600.1
    dotnet Framework 2.0.50727.3615


I also get an issue when I use the Format SQL, it appears with a dialog box "Notify Red Gate of this error"
jase74
 
Posts: 4
Joined: Wed May 16, 2007 10:56 am

Postby Paul Stephenson » Tue Jun 14, 2011 12:04 pm

Hi jase74,

Thanks for your bug report and I'm sorry SQL Prompt is causing you problems.

We believe this is caused by a bug in the installation of some Microsoft components that unregister a DLL needed by SQL Prompt. Please try the following from a Command Prompt:

Code: Select all
regsvr32 "%commonprogramfiles%\\microsoft shared\\msenv\\textmgrp.dll"


Regards,
Paul
Paul Stephenson
Project Manager, Red Gate
Paul Stephenson
 
Posts: 109
Joined: Fri Jul 23, 2010 9:22 am
Location: Cambridge, UK

Postby jase74 » Wed Jun 15, 2011 7:56 am

Thanks, this has resolved the problem
jase74
 
Posts: 4
Joined: Wed May 16, 2007 10:56 am

TextMgrP.dll

Postby thejamie » Tue Nov 08, 2011 4:39 pm

Noticed that this file became un-registered upon a Repair of Team Explorer 2008.
thejamie
 
Posts: 3
Joined: Fri Oct 28, 2011 7:59 pm

Re:

Postby Kiwi Chibi » Sun Dec 09, 2012 8:42 pm

When you try to register a dll through regsrv32, and run into this "the module was loaded but the call to dllregisterserver failed with error code" error, mostly likely you are running on Vista or Windows 7. If this is the case, you have have to go to Start->All Programs->Accessories, then right click on the "Command Prompt", choose the "Run as administrator" option.

Paul Stephenson wrote:Hi jase74,

Thanks for your bug report and I'm sorry SQL Prompt is causing you problems.

We believe this is caused by a bug in the installation of some Microsoft components that unregister a DLL needed by SQL Prompt. Please try the following from a Command Prompt:

Code: Select all
regsvr32 "%commonprogramfiles%\\microsoft shared\\msenv\\textmgrp.dll"


Regards,
Paul
Andrew
Kiwi Chibi
 
Posts: 1
Joined: Sun Dec 09, 2012 8:33 pm

Postby KingBBQ » Fri Aug 09, 2013 3:37 pm

Thanks a lot - that also solved my problem! Live without SQL Prompt is just not worth developing :-)
KingBBQ
 
Posts: 2
Joined: Wed Jan 16, 2013 5:10 pm


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 1 guest