On-demand training: More Gems from the SQL Prompt Treasure Chest. Watch now.

SQL Prompt v10.5.2.17186 unusable after update

I was previously on v10.3.x (I forget the full version) but after updating today to v10.5.2.17186 the tool will not load. I get the Redgate error dialog and all it says is "The process cannot access the file because it is being used by another process.". Any quick fix for this before I have to uninstall and revert to a previous version?

Best Answer

Answers

  • jnowlinjnowlin Posts: 6 New member
    Here is the log file contents:

    2020-12-17 13:07:49.276 -06:00|Information||| Launching package entry point Ssms18 (version 15.0.18358.0) for SQL Prompt 10.5.2.17186.
    2020-12-17 13:07:49.298 -06:00|Information||| Starting new SQL Prompt 10.5.2.17186 editor session
    2020-12-17 13:07:49.561 -06:00|Information||| BaseConnect(RedGate.SQLPrompt.SsmsPackage18.ConnectAdapter) constructed successfully
    2020-12-17 13:08:00.961 -06:00|Information||| Initialising DTE and AddIn connections.
    ***
    DTE.FullName = C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe, DTE.Version = 2019.0150,
    DTE.CommandLine = ,
    ***
    AddIn.Name = SQL Prompt, AddIn.ProgID = RedGate.SQLPrompt.Package,
    AddIn.Description = SQL Prompt
    2020-12-17 13:08:00.965 -06:00|Information||| Current culture en-US
    2020-12-17 13:08:00.967 -06:00|Information||| AddIn.SatelliteDllPath = null
    2020-12-17 13:08:01.288 -06:00|Error||| Report error dialog UI shown
    2020-12-17 13:08:22.588 -06:00|Information||| Exception report ('The process cannot access the file because it is being used by another process.') processed.

  • jnowlinjnowlin Posts: 6 New member
    Can someone please provide a direct link to the latest 10.4 version? The download older versions doesn't provide it.
  • jnowlinjnowlin Posts: 6 New member
    I pieced one together from other posts and release notes. In case anyone runs into this same problem and needs to revert here is the URL https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.4.7.16599.exe

    I am now back up and running and have to try upgrading to 10.5 later.
  • jnowlinjnowlin Posts: 6 New member
    I pieced one together from other posts and release notes. In case anyone runs into this same problem and needs to revert here is the URL:

    https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.4.7.16599.exe

    I am now back up and running again. I will have to try updating to 10.5 at a later time.
Sign In or Register to comment.