The latest stable build of SQL Prompt is 9.2.9.6459 (13th September)

Michael ClarkMichael Clark Posts: 120 Silver 4
edited September 13, 2018 2:12PM in SQL Prompt
Download SQL Prompt

What's new?

This build of SQL Prompt includes these improvements:
  • SP-7140 : Fixed a problem with the initialisation of the List of Code Analysis Issues.
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
Tagged:

Comments

  • WhoeverWhoever Posts: 3 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
  • 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: 3 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.
  • 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: 3 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

  • 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
  • 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;
Sign In or Register to comment.