The latest stable build of SQL Prompt is 9.4.3.7121 (15th November)

Michael ClarkMichael Clark Posts: 120 Silver 4
edited November 15, 2018 2:57PM in SQL Prompt
Download SQL Prompt

What's new?

This build of SQL Prompt includes these improvements:
    • You can now automatically fix BP005 issues in your script.
    • SP-7241 : Fixed an error in insert semicolon refactoring.

    See the full release notes for full details

    Feedback

    If you find any issues with this release, please post them on this forum.

    If you have any suggestions for improvements, please post them on our suggestions forum so other users can vote for them.





    Michael Clark
    Technical Lead, SQL Prompt

    Comments

    • WhoeverWhoever Posts: 5 New member
      The SQL Prompt in the Toolbelt Essential, is that the full version, or you have another PRO that cost extra?  I disable the core in VS2017, see SQL Prompt, and it does not work with Microsoft Database Project.  Forum appears to say that's a Pro feature?  Thanks
    • RichardLRichardL Posts: 418 Gold 4
      Hi @Whoever

      Thanks for your post. 

      The version in Toolbelt Essentials is the full version. 

      I hope this helps. 

      Richard Lynch. 
      Customer Support
      Redgate Software
    • WhoeverWhoever Posts: 5 New member
      Thanks.  Any idea why it doesn't work with Microsoft Database Project (SSDT)? 

      I connect to SQL, open query, prompt works perfectly. 

      Open a SSDT project, open a storedproc.sql script file, only standard SQL keywords like SELECT show up.  Nothing else popup, not even table names. 

      I read several forum replies mentioned Prompt Pro works with SSDT. 
    • EP_EP_ Posts: 2 New member
      An alias referenced within an "[not] exists" clause is no longer updated when the alias is renamed.
    • EP_EP_ Posts: 2 New member
      At least as of release 9.1.11.5038, column suggestions (Intellisense) no longer work in correlated subqueries when referencing a table/alias outside of the subquery's scope.
    • RichardLRichardL Posts: 418 Gold 4
      Hi @EP_

      Thanks for your posts. 

      Can you try the latest version instead? It is available below for download and was released yesterday. 
      ftp://support.red-gate.com/patches/SQLPrompt/16May2018/SQLPrompt_9.1.12.5083.exe

      Kind regards

      Richard Lynch. 
      Customer Support
      Redgate Software
    • WhoeverWhoever Posts: 5 New member
      Just tried the latest 5083, no intellisense inside Microsoft SSDT project.  I replicate the issue by creating an empty SSDT project, with Table1 and TestProc1.  When I type in the TestProc1, SELECT popup, so are project namespace and dbo schema, but there's no table name at all.  Tried rebuild project, refresh suggestion, different namespace and schema, same result.  Once connecting to live SQL, everything works fine.

      CREATE TABLE [dbo].[Table1]
      (
      [Id] INT NOT NULL PRIMARY KEY, 
          [UserName] VARCHAR(50) NULL
      )

      CREATE PROCEDURE [dbo].[TestProc1]
      AS 
      BEGIN 
      SELECT * FROM ta
      END

    • RichardLRichardL Posts: 418 Gold 4
      Hi @Whoever

      Thanks for your reply. 

      This might be something a support engineer can help you with then so please send us a ticket if you have a support contract with your serial key. 

      Kind regards

      Richard Lynch. 
      Customer Support
      Redgate Software
    • myuabovmyuabov Posts: 11 Bronze 3
      Hello, I've just installed the SQL Prompt 9 Version 9.1.13.5130 update and I'm getting an error message trying to Format SQL (Ctrl+K, Ctrl+Y): "Object reference not set to an instance of an object". I'm attaching a screenshot below.



      I've tried restarting SSMS then the PC and that didn't help.

      The debug log has the following errors:

      29 May 2018 21:23:13,415 [1] INFO  RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.1.13.5130, Culture=en-US, PublicKeyToken=7f465a1c156d4d57, let's have a go29 May 2018 21:23:13,417 [1] INFO  RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.1.13.5130, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.SQLPrompt.CommonControls.resources.dll
      29 May 2018 21:23:13,548 [1] ERROR RedGate.SQLPrompt.CommonUI.Refactor.RefactoringErrorReporter - Refactoring/Analysis failedSystem.NullReferenceException: Object reference not set to an instance of an object.

      The previous version worked fine. Any suggestions?

      Thanks,
      Mark
    • RichardLRichardL Posts: 418 Gold 4
      Hi @myuabov

      Thanks for your post. 

      This looks like something a support engineer should look at for you so please send us a ticket if you have a support contract on your serial key. Don't forget to include the sample script please if possible. 

      Kind regards

      Richard Lynch. 
      Customer Support
      Redgate Software
    • myuabovmyuabov Posts: 11 Bronze 3
      Thanks, Richard -- I've submitted a support request.
    • BillKBillK Posts: 2 New member
      Same issue as  @EP_ :  suggestions not working correctly for correlated subqueries.

      I was on 9.1.13.x and I updated to 9.1.14.5213 and it didn't fix the issue.

      I have used previous versions of SQL prompt over the years and I know this used to work flawlessly.

      Anyone else (other than @EP_ ; and I) seeing this?  Redgate?

      Thanks.
    • myuabovmyuabov Posts: 11 Bronze 3
      RichardL said:
      Hi @myuabov

      Thanks for your post. 

      This looks like something a support engineer should look at for you so please send us a ticket if you have a support contract on your serial key. Don't forget to include the sample script please if possible. 

      Kind regards

      Richard Lynch. 
      I believe this issue has been resolved in Version 9.1.15.5260. Thank you!
    • BillKBillK Posts: 2 New member
      I installed Version 9.1.15.5260 and the problem is not resolved (for me).

      As @EP_ said suggestions only appear for the inner table not the outer one.

      Is there some setting that must be configured to make the suggestions appear?

      I know this used to work in prior versions of the product.  I use exists a lot and it was always a time saver when tables had composite keys.
    • MoonshotMoonshot Posts: 1 New member
      I am not sure about anyone else.  I updated VS2017 to 15.8 and  SQL Prompt Cord to 9.2.5.6073.  Every time I try to start up a SQL editor in my IDE I get an exception.  I revert back to 9.2.0.5601 and everything works fine.  Any ideas?
    • NgainerNgainer Posts: 13 Bronze 1
      edited August 29, 2018 2:16PM
      I am seeing an issue when a column from a table is passed into a Table-valued function. The alias for the table is being removed from the column. This causes issues if there are multiple tables with the same column name. An error is generated saying the "the column name is ambiguous". Is there a way to not remove the table alias from a column being used with the CROSS APPLY operator?

      SELECT dc.AccessResult
           , c.CustomerID
           , c.CustomerName
           , c.DeliveryCityID
        FROM WideWorldImporters.Sales.Customers                                           AS c
       CROSS APPLY WideWorldImporters.Application.DetermineCustomerAccess(c.DeliveryCityID) AS dc
       WHERE c.CustomerID = 566;
    • kalokalo Posts: 57 Bronze 2
      edited October 4, 2018 8:38AM
      my pc just told me there was an update so i downloaded and clicked install. the wizard then ran, got to 97% and then said Finished. Could not install. without any explanation. Now i go into SSMS and SQL Prompt and Tab history seem to have totally disappeared.

      i've now re-intalled 9.2.6 from the link in the op and done an update to 9.3 successfully on second attempt
    • Does the latest release of Prompt support SSMS 18 preview 4 released by Microsoft on 24th Sept?

    • brentm said:
      Does the latest release of Prompt support SSMS 18 preview 4 released by Microsoft on 24th Sept?
      It does not.
    • woody__woody__ Posts: 1 New member
      edited November 16, 2018 5:40AM
      I installed 9.4.3.7121 today and SSMS keeps freezing since. I might be editing a stored procedure and move the cursor to a key words (for example "ALTER PROCEDURE") and a little icon in the sidebar keep flashing in the sidebar. If I look at the task manager there is a CefSharp.BrowserSubprocess task that is frozen and SSMS.


      EDIT: If I turn off "Enable Code Analysis" it no longer crashes.
    Sign In or Register to comment.