Search
-
Re: SQL Prompt not working when using AAD - Universal with MFA authentication
2024-04-18 13:52:14.864 -05:00 [Warning] Failed to load server xxxxxxxxMicrosoft.Data.SqlClient.SqlException (0x80131904): Login failed for user '<token-identified principal>'. at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at… -
Incrementing, from 1, based on another column
Hi, I have a table which simplified is a sales orders lines table, with two columns, a reference to the sales order (this is a FK) and an order line. The order line column should increment from 1 to x but be unique to that sales order ID. For example: SalesOrderID OrderLine 1 1 1 2 1 3 2 1 2 2 3 1 And so on. Currently the… -
Source Control Data: Removing grouping option
Hi, it's possible to remove grouping option in files export option ? It's really hard to make some code review when i add a new row and this row go on top of the file and at next commit my first row after go at his place in the middle First commit INSERT INTO [dbo].[GroupFunction] ([GroupId], [FunctionId]) VALUES (1,… -
Re: Update has caused Prompt to stop working
Hello! Another victim of the latest update. I updated to 10.14.6.5992 yesterday and my suggestions stopped for Azure Synapse (PDW) databases. Also hangs when suggestion load is trying to connect to 'master'. Any help is appreciated. Below are log entries. ClientConnectionId:37e03af8-c660-48e1-85cb-7bb5cf73f975Error… -
Generic "Scripts Folder Command" error when getting latest
I am receiving the following error when attempting to get latest on 1 of 5 databases. All other databases correctly return results. Below is the full error message I'm receiving. Scripts Folder Command at RedGate.SQLDataCompare.Engine.ComparisonSession.GetTableReaders(ITableReader& reader1, ITableReader& reader2,… -
Connecting with Active Directory Password Authentication
Hi! Setup* Microsoft SQL server in Azure (V12) * SQL Server 2016 Management Studio 13.0.15000.23 * Redgate SQL Prompt 7.2.4.291 We are using Active Directory Password Authentication to connect to our databaseinstance. However, when SQL Prompt is loading I get the following log (Verbose logging on): 27 Jun 2016 10:56:05,693… -
Re: Setting are not saved
-
schema validation failed on create schema
Hi, I get following error when trying to build a package: I have 2 schema declarations: CREATE SCHEMA [Internal] AUTHORIZATION [dbo] GO CREATE SCHEMA [Util] AUTHORIZATION [dbo] GO I'm executing below command (without the masking): sqlci.ps1 -Verbose Build -scriptsFolder *** -packageId myDB-packageVersion 0.4-master… -
THROW
Hi Redgate Team! SQL Prompt will format the following statement BEGIN TRY RAISERROR('test', 16, 1);END TRYBEGIN CATCH SELECT 1 THROWEND CATCH; like this BEGIN TRY RAISERROR('test', 16, 1);END TRYBEGIN CATCH SELECT 1 THROW;END CATCH; Which is wrong - instead it should be formatted like BEGIN TRY RAISERROR('test', 16, 1);END… -
SQL Prompt 7.5.0.912 - IF ELSE formatting not working as advertised
After upgrading to version 7.5.0.912, and typing the following into a query window: IF 1 =1 PRINT 'HELLO' ELSE IF 2=1 PRINT 'Good Bye' This is what I got after doing the Format: IF 1 = 1 PRINT 'HELLO'; ELSE IF 2 = 1 PRINT 'Good Bye'; I was expecting the ELSE IF to be on the same line. I did a reset to the default…
>5989 results