Comments
Sort by recent activity
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. / comments
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 t...
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. / comments
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...
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. / comments
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...