Search
-
.NET Error when trying to run SQL Prompt Command Line
When running the SQL Prompt command line, I get this error. Unhandled Exception: System.IO.FileLoadException: Could not load file or assembly 'System.Memory, Version=4.0.1.1, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The located assembly's manifest definition does not match the assembly… -
Re: SQL Prompt not working
I am running into this same issue. Logs show the following error: 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… -
Re: First migration not running in existing database after initial baselining.
-
Why does one server continue to disconnect and reconnect within redgate sql monitor?
Hi, I am not sure if this has been brought up before nor do I have time to look through the forum for this issue. I am reaching out for help because this is really bothering us as to why this continues to happen. We have the redgate sql monitor and we have 4 db servers that it's monitoring. We have one server that… -
Source Control causing SSMS to crash frequently
This seems to happen when I introduce a new server and try and act with it in the object browser. Happening frequently since yesterday morning. Once it started happening I updated my source-control to the latest version but it is still happening. Error log below. FYI: this is also coinciding with an issue where SSMS… -
Custom Alert Not Clearing
On the lastest version (13.0.53.1762) and I've noticed that at least one custom alert is not clearing: The metric is collected in each user database and runs the following query (returning 1 if the database is not encrypted with native TDE). I can test the query on the database in question and it returns the expected value… -
How to make all types of merged assemblies internal?
I am using the following construct in my saproj: <Assembly AssemblyName="MyCompany.LibA, Culture=neutral, PublicKeyToken=null"> <Merging Merge="1"> <Pruning> <Exclusion /> </Pruning> <Obfuscation Obfuscate="1"> <Exclusion /> </Obfuscation> <ControlFlow Obfuscate="1" /> <MemberRefsProxy /> <ResourcesCompression />… -
Monitoring Azure SQL DB Using Managed Identity
Has anyone manage to monitor a Azure SQL DB from Redgate monitor using user define managed Identity, we have got a bit stuck Cannot connect to SERVERNAME-pr.database.windows.net. =================================== ManagedIdentityCredential authentication unavailable. Multiple attempts failed to obtain a token from the… -
Missing indentation after WHILE
* SQL Prompt version: 10.14.4.4865 * SQL Server Management Studio version: 19.2.56.2 * SQL Server Version: * Microsoft SQL Azure (RTM) - 12.0.2000.8 * Microsoft SQL Server 2022 (RTM-GDR) (KB5029379) - 16.0.1105.1 (X64) * Database Compatibility Level: 160 * Active Style: Default Before formatting DECLARE @i INT = 1; IF @i =… -
JSON_OBJECT causes Incorrect syntax near ':'.
While trying to deploy a DB project using a PS1 script the following error occurred: "Incorrect syntax near ':'" 'JSON_OBJECT( ''DemographicID'':1 ABSENT ON NULL) as payload' Using the above string in the creation of a dynamic INSERT command causes the error. I have tried numerous ways to work around this, but any attempt…
>5989 results