Search
-
Re: Connection failed Internal SQL Monitor error "namespace root/mscluster is invalid"
-
Unable to get profiler to connect to IIS - ASP.NET on webserver
Getting a System.IO.IOException: Pipe write operation failed with code 0xe8 Have disabled all antivirus on webserver. it feels like a permissions issue or maybe some windows feature is not installed? any suggestions would be appreciated! here is the stack: 07 Aug 2023 12:33:03.479 [Profiler pipe monitor] INFO… -
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… -
Collapse CASE statements
The "Collapse CASE statements shorter than N characters" option appears to conflict with the Lists --> List items --> "Place first item on new line" option, when the first expression in a SELECT statement is a CASE expression. When I have "Place first item on new line" set to Always and "Collapse CASE statements"… -
MySQL Data Compare bug report
I have sent an email to your company but never heard and answer so trying here ... I need to get missing data out of the db. Also this is just going to migrate it over and keep the new stuff right ? here is the error Bug report generated at 3/13/2012 4:08:17 AM Program version 1.0.0.351 System.Exception: When deploying… -
SQL Source Control
I want to buy SQL Source Control for my company and needed some clarification. Came across the pricing below and not sure about the '1 license' part. $495 Total (excluding VAT) 1 license 1 year of support & upgrades What is 1 licence means? 1 User? 1 user multiple activation? 1 Machine? if means 1 user multiple activation,… -
Formatting help
Discussion by CraigRichards · · Home› Discontinued and Previous Versions› SQL Prompt Previous VersionsDoes anyone know how to get the following formatting to work? From IF EXISTS ( SELECT TOP 1 1 FROM inserted ) IF EXISTS ( SELECT TOP 1 1 FROM deleted ) /*Update Block*/ To IF EXISTS ( SELECT TOP 1 1 FROM inserted ) IF EXISTS ( SELECT TOP 1 1 FROM deleted ) AND This FROM deleted INNER JOIN INSERTED ON DELETED.PeopleId =… -
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… -
How to generate the consistent result for multiple days of data.
I am using SQL Data generator first time and trying to generate the data for following scenario for stress test. Scenario : I am trying to populate the MasterData in DailyFeedData table for each Business Day. BusinessDay_Id and MasterData_Id are foreign keys. The problem is Generator is populating the data in random… -
Re: Build server pipeline failing after auto-update of SQL Change Automation (v 4.4.22194.30982)
Hi It looks like a similar issue might have occurred again? TeamCity server version is 2022.10.2 (build 117025)RedGate SQL Change Automation Plugin: 5.0.7 [15:38:05] : [Step 1/6] Invoke-DatabaseBuild, SQL Change Automation 4.5.23032.654, Copyright ¸ Red Gate Software Ltd 2014-2023 ... [15:38:05] : [Step 1/6]…
>5978 results