Red Gate forums :: View topic - SQL Prompt Hanging
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 5
SQL Prompt 5 forum

SQL Prompt Hanging

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
jase74



Joined: 16 May 2007
Posts: 4

PostPosted: Mon Jun 13, 2011 4:26 pm    Post subject: SQL Prompt Hanging Reply with quote

I'm using SQL Server Management Studio and everytime use the Uppercase Keywords menu item from prompt, it hangs Management Studio.
Back to top
View user's profile Send private message
jase74



Joined: 16 May 2007
Posts: 4

PostPosted: Mon Jun 13, 2011 5:01 pm    Post subject: Reply with quote

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"
Back to top
View user's profile Send private message
Paul Stephenson



Joined: 23 Jul 2010
Posts: 109
Location: Cambridge, UK

PostPosted: Tue Jun 14, 2011 12:04 pm    Post subject: Reply with quote

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:
regsvr32 "%commonprogramfiles%\microsoft shared\msenv\textmgrp.dll"


Regards,
Paul
_________________
Paul Stephenson
Project Manager, Red Gate
Back to top
View user's profile Send private message Send e-mail
jase74



Joined: 16 May 2007
Posts: 4

PostPosted: Wed Jun 15, 2011 7:56 am    Post subject: Reply with quote

Thanks, this has resolved the problem
Back to top
View user's profile Send private message
thejamie



Joined: 28 Oct 2011
Posts: 3

PostPosted: Tue Nov 08, 2011 4:39 pm    Post subject: TextMgrP.dll Reply with quote

Noticed that this file became un-registered upon a Repair of Team Explorer 2008.
Back to top
View user's profile Send private message
Kiwi Chibi



Joined: 09 Dec 2012
Posts: 1

PostPosted: Sun Dec 09, 2012 8:42 pm    Post subject: Re: Reply with quote

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:
regsvr32 "%commonprogramfiles%\microsoft shared\msenv\textmgrp.dll"


Regards,
Paul

_________________
Andrew
Back to top
View user's profile Send private message
KingBBQ



Joined: 16 Jan 2013
Posts: 2

PostPosted: Fri Aug 09, 2013 3:37 pm    Post subject: Reply with quote

Thanks a lot - that also solved my problem! Live without SQL Prompt is just not worth developing Smile
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group