Activity overview
Latest activity by Ngainer
RedGate Platform Not Showing after Update in Help Menu
The RedGate platform option in the help menu is not showing after upgrading to 10.8.1.23216.
Incorrect source control folder selected when database name exists in multiple source control folder
When deploying a database from SSMS with the source selected as Latest Head, when SQL Compare is launched, the wrong database is selected if the database name resides in multiple folders in TFS.
[image] This also causes SSMS to crash. / comments
This also causes SSMS to crash.
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
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...
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
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...
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
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...
Error Laying Out SQL on 9.1.4.4532
The bug fix in the latest release worked but caused a new issue: SP-6865 : 'Align data types and constraints' schema (DDL) formatting option could cause an argument null exception.Now the "Format S...
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
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...
This is the same error I am receiving on the other thread "Error laying out SQL". / comments
This is the same error I am receiving on the other thread "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. / comments
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.