How can we help you today? How can we help you today?

SQL Prompt Stopped Working

Starting last Friday, SQL Prompt stopped working.

When selecting the "options" menu, all selections are disabled and the "Use SQL Prompt" option is unchecked (and disabled).

Doing some digging, in the log are a number of entries similar to the following (corresponding to when SSMS was started):
20 Jul 2009 14:45:45,518 [1] INFO RedGate.SqlPrompt.Engine.LogService - Starting new SQL Prompt editor session
20 Jul 2009 15:05:40,932 [8] 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.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
20 Jul 2009 15:05:51,994 [7] 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.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()

I tried renaming the folder C:\Documents and Settings\<User>\Local Settings\Application Data\Red Gate\SQL Prompt 4, thinking that this may recreate some settings that got corrupted or otherwise were causing problems. However that did nothing to fix the problem.

Any ideas?

Marc Butenko
mbutenko(at)mt.gov
mbutenko
0

Comments

3 comments

Sort by
  • tanya
    Hi Marc,

    Have you upgraded your build to the beta version that is available for download from http://www.red-gate.com/MessageBoard/vi ... php?t=9215
    If not, that would explain the problem as our early access version of the build was time-bombed to expire on 10th July 09. Unfortunately we did not have any informative error dialog when the product trial expires but we are fixing that issue with SQL Prompt v4 release:)
    Apologies for the inconvenience caused and let me know if that worked.

    Thanks,
    Tanya
    Project Manager
    Red Gate Software Ltd
    tanya
    0
  • mbutenko
    I did not, that probably explains it. I did try to update from within SQL Prompt, but it said I was up to date. So I am assuming that this new version was not available via the update.

    Anyway, the link below fixed the problem.

    Thanks!
    mbutenko
    0
  • tanya
    Ah...Check for updates actually checks for product versions against Red-Gate website which holds v3.9 as v4.0 is not yet released.
    As these are development pre-release builds, they are higher versions than the ones in the website and so check for updates wouldn't be of any help in these cases:-|

    Sorry for the confusion...but am glad it is all sorted now:)

    Thanks,
    Tanya
    Project Manager
    Red Gate Software Ltd
    tanya
    0

Add comment

Please sign in to leave a comment.