How can we help you today? How can we help you today?
Ngainer
Activity overview Badges (0) Posts (4) Comments (11)

Comments

Sort by recent activity
I reverted to version 9.2.6.6145 and everything seems to be working again. We have been experiencing the same issues as above. Makes SSMS totallly unusable. Current environment info: Microsoft SQL Server Management Studio 14.0.17277.0 Microsoft Analysis Services Client Tools 14.0.1016.262 Microsoft Data Access Components (MDAC) 10.0.17134.1 Microsoft MSXML 3.0 6.0  Microsoft Internet Explorer 9.11.17134.0 Microsoft .NET Framework 4.0.30319.42000 Operating System 6.3.17134 / comments
  1. Community
  2. SQL Prompt
  3. Latest version of SQL Prompt (9.2.7.6282) causing SSMS (17.8.1) to hang?
I reverted to version 9.2.6.6145 and everything seems to be working again. We have been experiencing the same issues as above. Makes SSMS totallly unusable. Current environment info:Microsoft SQL S...
0 votes
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; / comments
  1. Community
  2. SQL Prompt
  3. The latest stable build of SQL Prompt is 9.4.15.8960 (28th of March 2019)
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 wit...
0 votes
It actually looks like it is caused by the inclusion of this from the release notes: Added refactoring option to prefix 'N' to literal strings when assigning to a unicode NCHAR/NVARCHAR variable. Found under Prompt -> Options -> Style. This was defaulted to checked after my upgrade and started causing Format SQL to fail. After unchecking this option, it is working again. It seems to be having trouble with sysname data type. / comments
  1. Community
  2. SQL Prompt
  3. Error Laying Out SQL on 9.1.4.4532
It actually looks like it is caused by the inclusion of this from the release notes:Added refactoring option to prefix 'N' to literal strings when assigning to a unicode NCHAR/NVARCHAR variable. Fo...
0 votes
This is the same error I am receiving on the other thread "Error laying out SQL". / comments
  1. Community
  2. SQL Prompt
  3. SQL Format doesn't format function
This is the same error I am receiving on the other thread "Error laying out SQL".
0 votes
I believe I have found the option that is causing the bug. The option "Align data types and constraints" in the "Schema (DDL)" group seems to cause the provided styles to fail. If I uncheck this option on any of my custom styles, the error goes away.[image] [image] / comments
  1. Community
  2. SQL Prompt
  3. Error laying out SQL
I believe I have found the option that is causing the bug. The option "Align data types and constraints" in the "Schema (DDL)" group seems to cause the provided styles to fail. If I uncheck this op...
0 votes
I am getting the same error: [image] It seems to happen on CREATE or ALTER scripts. If I change the above code to a DECLARE statement instead of a CREATE or ALTER PROCEDURE then it formats fine. [image] / comments
  1. Community
  2. SQL Prompt
  3. Error laying out SQL
I am getting the same error: It seems to happen on CREATE or ALTER scripts. If I change the above code to a DECLARE statement instead of a CREATE or ALTER PROCEDURE then it formats fine.
0 votes
The issue seams to be happening on Formatting Styles that are user-defined. If I change to one of the REDGATE STYLES in the "Formatting styles" window then the code is formatted correctly. / comments
  1. Community
  2. SQL Prompt
  3. Error laying out SQL
The issue seams to be happening on Formatting Styles that are user-defined. If I change to one of the REDGATE STYLES in the "Formatting styles" window then the code is formatted correctly.
0 votes
James, You are correct. I am able to select the type now in Object Explorer. It must have been a refresh issue. I am still not able to search for the User-Defined Table Type in SQL Search. Are you able to find any types that have been created in SQL Search by name? Thank you! Nathanial / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt will not "Select in Object Explorer" for User-Defined Table Types.
James, You are correct. I am able to select the type now in Object Explorer. It must have been a refresh issue. I am still not able to search for the User-Defined Table Type in SQL Search. Are you ...
0 votes
David, I have tested the fix and everything seems to be working as expected. The version I'm using is 7.3.0.450. Just giving this for validation. Thank you for fast feedback. I'm very impressed! Nathanial / comments
  1. Community
  2. SQL Prompt
  3. New "Edit Formatting Styles" beta feature for SQL Prompt
David, I have tested the fix and everything seems to be working as expected. The version I'm using is 7.3.0.450. Just giving this for validation. Thank you for fast feedback. I'm very impressed! Na...
0 votes
David, I would be glad to. Let me know when it is availabile and I will test it out. Thank you! Nathanial / comments
  1. Community
  2. SQL Prompt
  3. New "Edit Formatting Styles" beta feature for SQL Prompt
David, I would be glad to. Let me know when it is availabile and I will test it out. Thank you! Nathanial
0 votes
Total activity
23
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
8