Search
-
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,… -
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… -
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,… -
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 xxxxxxxx Microsoft.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… -
Can not get access to localDb
When attempting to install server components for localDb, I get could not find (shows my machine name) which is the machine I'm on and zero problem when doing the same for SQLEXPRESS (which works). So step 1 fails and I am a admin on this machine, step 2 validates, never get to step 3 but selected windows authentication. -
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… -
Re: memory issue
-
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…
>5993 results