The latest stable build of SQL Prompt is 9.4.15.8960 (28th of March 2019)

• 
  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

  Whoever March 29, 2018 15:58

  - 0 +
• 
  Hi @Whoever
  
  Thanks for your post. 
  
  The version in Toolbelt Essentials is the full version. 
  
  I hope this helps. 
  
  Richard Lynch. 

  RichardL March 30, 2018 15:46

  - 0 +
• 
  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. 
  

  Whoever March 30, 2018 16:00

  - 0 +
• 
  An alias referenced within an "[not] exists" clause is no longer updated when the alias is renamed.

  EP_ May 14, 2018 21:56

  - 0 +
• 
  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.

  EP_ May 17, 2018 16:58

  - 0 +
• 
  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. 

  RichardL May 17, 2018 17:58

  - 0 +
• 
  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

  
  

  Whoever May 17, 2018 18:24

  - 0 +
• 
  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. 

  RichardL May 17, 2018 18:26

  - 0 +
• 
  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:
  
  

  <div>29 May 2018 21:23:13,415 [1] INFO&nbsp; 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 go</div><div>29 May 2018 21:23:13,417 [1] INFO&nbsp; 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</div><div><br><div>29 May 2018 21:23:13,548 [1] ERROR RedGate.SQLPrompt.CommonUI.Refactor.RefactoringErrorReporter - Refactoring/Analysis failed</div><div>System.NullReferenceException: Object reference not set to an instance of an object.</div></div><div></div>

  
  

  The previous version worked fine. Any suggestions?
  
  Thanks,
  Mark
  

  myuabov May 29, 2018 22:23

  - 0 +
• 
  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. 

  RichardL May 30, 2018 12:51

  - 0 +
• 
  Thanks, Richard -- I've submitted a support request.

  myuabov May 30, 2018 16:22

  - 0 +
• 
  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.

  BillK May 31, 2018 15:01

  - 0 +
• 

  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!

  myuabov June 07, 2018 20:14

  - 0 +
• 
  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.

  BillK June 08, 2018 15:28

  - 0 +
• 

  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?

  Moonshot August 15, 2018 14:49

  - 0 +
• 
  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;

  Ngainer August 29, 2018 14:07

  - 0 +
• 
  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

  kalo October 04, 2018 08:26

  - 0 +
• 
  Does the latest release of Prompt support SSMS 18 preview 4 released by Microsoft on 24th Sept?

  brentm October 04, 2018 23:23

  - 0 +
• 
  
  

  brentm said:

  Does the latest release of Prompt support SSMS 18 preview 4 released by Microsoft on 24th Sept?

  It does not.
  

  Russell D November 15, 2018 14:55

  - 0 +
• 
  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.

  woody__ November 16, 2018 05:29

  - 0 +
• 
  Woody - I have been struggling with the exact same issue with 9.4.3.7121.   Thanks for the workaround suggestion!!!

  mmcnamara November 20, 2018 17:59

  - 0 +
• 

  woody__ said:

  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.

  Thank you for this.  I couldn't figure out how to make it stop!

  wschillo November 23, 2018 08:59

  - 0 +
• 

  woody__ said:

  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.

  Thank you for this.  I couldn't figure out how to make it stop!

  wschillo November 23, 2018 08:59

  - 0 +
• 
  Since installing this update I am no longer given any suggestions for any result in the connected database.
  
  I also have the same issue as @wschillo and @woody__ above, with Code Analysis switched on, SSMS constantly freezes, so I've turned it off.
  
  I'm running 9.4.4.7199

  akythor November 27, 2018 10:08

  - 0 +
• 
  I just updated to 9.4.5.7296 and it looks like it didn't fix the issue of removing aliases from a table valued function's argument list. However, instead of stripping them completely it's sometimes leaving one on and other times it removes them all.
  
  For example, this:
  CROSS APPLY dbo.FormatTIN(I.TIN, I.TIN_TYPE) AS FT<br>
  reformats as this:
  CROSS APPLY dbo.FormatTIN(I.TIN, TIN_TYPE) AS FT<br>
  But this:
  CROSS APPLY dbo.FormatPhoneNbr(P.AREA_CODE, P.PREFIX, P.NUMBER, 1) AS FPN<br><br>reformats as this:
  CROSS APPLY dbo.FormatPhoneNbr(AREA_CODE, PREFIX, NUMBER, 1) AS FPN
  

  cmfox1970 December 05, 2018 23:49

  - 0 +
• 
  I upgraded from 9.3 to 9.4.14 and lost intellisense.  I have closed and restarted, hit manual refresh.  Not a good experience.

  DataDaveMN March 27, 2019 14:06

  - 0 +
• 
  I'm unable to see suggestions in SSMS for cross server tables. Even if I refresh it doesn't work. I'm using version 9.4.15.8960. Can someone tell me where to get a previous version (not 8 and prior) of SQL Prompt 9 so I can revert back until they fix this?
  

  haizman April 05, 2019 15:02

  - 0 +
• 
  Are you referring to Linked Servers?
  

  Russell D April 05, 2019 15:05

  - 0 +
• 
  Yes I am. I am unable to see any suggestions when using linked servers.
  

  haizman April 05, 2019 15:06

  - 0 +
• 
  See https://forum.red-gate.com/discussion/85055/intellisense-no-longer-working-for-linked-servers.
  
  

  Russell D April 05, 2019 15:06

  - 0 +

Add comment

Please sign in to leave a comment.