Red Gate forums :: View topic - SQL Prompt freezes my Management Studio
Return to www.red-gate.com RSS Feed Available

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

SQL Prompt freezes my Management Studio

Search in SQL Prompt Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
geller_eugene



Joined: 01 Apr 2009
Posts: 4

PostPosted: Wed Apr 01, 2009 5:52 pm    Post subject: SQL Prompt freezes my Management Studio Reply with quote

Terrific product, I used it all the time on my old computer (Windows Server 2003 x86), but then, after I upgraded (Windows Server 2008 x64), SQL Prompt just freezes my Management Studio for a while. It would unfreeze for a couple of seconds, and the only way for me to actually do some work is to disable it, but then I can't use it. I use Management Studio 2008, I just checked for updates and I am running the latest version of the product.

Here is the full version numbers of my tools:

Microsoft SQL Server Management Studio
10.0.1600.22 ((SQL_PreRelease).080709-1414 )

Microsoft Analysis Services Client Tools
2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )

Microsoft Data Access Components (MDAC)
6.0.6001.18000 (longhorn_rtm.080118-1840)

Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 8.0.6001.18702
Microsoft .NET Framework 2.0.50727.3074
Operating System 6.0.6001

SQL Prompt version 3.9.0.43


Here's the log:

01 Apr 2009 16:26:43,588 [1] INFO RedGate.SqlPrompt.Engine.LogService - Starting new SQL Prompt editor session
01 Apr 2009 16:39:12,564 [1] ERROR RedGate.SqlPrompt.Engine.LogService - Invalid second child for alias table. Was expecting an identifier (727) but found element of type 23.
01 Apr 2009 16:39:12,567 [1] ERROR RedGate.SqlPrompt.Engine.LogService - R
01 Apr 2009 16:39:12,589 [1] ERROR RedGate.SqlPrompt.Engine.LogService - at RedGate.SqlPrompt.Engine.Candidates.DerivedTableCandidate.a(SqlPromptEngine , cE , Element )
at RedGate.SqlPrompt.Engine.Candidates.DerivedTableCandidate..ctor(SqlPromptEngine engine, ISqlInfo parent, cE astMap, Element tableSubquery)
at ce.e(SqlPromptEngine , cE , Element )
01 Apr 2009 16:46:03,243 [22] ERROR RedGate.SqlPrompt.Engine.LogService - LogService caught unhandled exception in AppDomain: 'Thread was being aborted.'
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.SleepInternal(Int32 millisecondsTimeout)
at u.a()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.runTryCode(Object userData)
at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()


Please let me know what I can do to let all my software coexist Smile

Thank you.
Back to top
View user's profile Send private message
Linda Hawksworth



Joined: 25 Jun 2007
Posts: 192

PostPosted: Tue Apr 07, 2009 10:34 am    Post subject: Reply with quote

Are you working over a VPN? We have a patch release to improve performance in these situations.
Back to top
View user's profile Send private message
geller_eugene



Joined: 01 Apr 2009
Posts: 4

PostPosted: Tue Apr 07, 2009 7:44 pm    Post subject: Reply with quote

No, I am not working over a VPN. One other thing I did not mention is that my queries reference several different servers by aliases. When all our servers were SQL Server 2000 and I was on a 32-bit Windows Server 2003, it worked fine. Then I switched computers and now, in addition, one of the servers is actually a SQL Server 2005.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6648

PostPosted: Tue Apr 14, 2009 6:33 pm    Post subject: Reply with quote

I would suggest going into cache management and clearing everything out. It could be that there is some cunfusion between some cached databases if you are using aliases.
Back to top
View user's profile Send private message
geller_eugene



Joined: 01 Apr 2009
Posts: 4

PostPosted: Tue Apr 14, 2009 6:49 pm    Post subject: Reply with quote

Brian,

Thank you for your reply. I enabled SQL Prompt, cleared cache, but it did not work. I had a query opened with aliases and SQL Server Management Studio started freezing almost instantly. Once I could get to the menu, I formatted a query and here's the log:

13 Apr 2009 17:15:49,971 [1] INFO RedGate.SqlPrompt.Engine.LogService - Starting new SQL Prompt editor session
13 Apr 2009 17:16:25,275 [27] ERROR RedGate.SqlPrompt.Engine.LogService - LogService caught unhandled exception in AppDomain: 'Thread was being aborted.'
System.Threading.ThreadAbortException: Thread was being aborted.
at Microsoft.VisualStudio.Package.LanguageService.ParseThread()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()


Management Studio kept locking up for a while so I had to disable SQL Prompt again.
Back to top
View user's profile Send private message
jerryhung



Joined: 28 Dec 2007
Posts: 116

PostPosted: Fri Apr 17, 2009 5:05 pm    Post subject: Reply with quote

geller

Do you have anything else installed? SSMS Tools Pack or etc...
I'd uninstall SQL Prompt, restart, make sure SSMS works fine
re-install SQL Prompt again, and see how it works
_________________
Jerry Hung
DBA, MCITP
Back to top
View user's profile Send private message
geller_eugene



Joined: 01 Apr 2009
Posts: 4

PostPosted: Tue Jul 21, 2009 9:37 pm    Post subject: Reply with quote

I got some more information. The freeze only occurs when a 2000 server instance is trying to get to the 2005 server instance by alias which is not configured (I am opening last year's queries for the report and back then all the servers were SQL Server 2000).

It freezes for about 30 seconds, then I am able to go in to the menu and disable SQL Prompt, then it works.
Back to top
View user's profile Send private message
hrc1966



Joined: 07 Jun 2011
Posts: 1

PostPosted: Tue Jun 07, 2011 10:17 am    Post subject: Still not solved Reply with quote

I found (a lot of) the same entries in my event log today. Will you inform us when the issue is fixed or how to we can fix it?

(US Windows 7, 64-bit)
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