Search
-
Re: SQL History Search not working
I found this in the sql history error log: 2024-04-17 13:56:24.674 -04:00 [Error] Error processing command: StoreContentsRevision System.FormatException: Additional non-parsable characters are at the end of the string. at J2N.Numerics.ParseNumbers.StringToLong(String s, Int32 radix, Int32 flags, Int32 sign, Int32& currPos,… -
SmartAssembly 8 - "System.IO.FileNotFoundException: Could not load file or assembly" error
We got an error while starting the SmartAssembly8, it was worked before but the missed file name is not present on error System.TypeInitializationException: The type initializer for '?.' threw an exception. ---> System.IO.FileNotFoundException: Could not load file or assembly '{54781419-5079-424e-a2cd-a3bd3c4a5eb2},… -
Re: Why Script Object as ALTER not working for SQL Pool on Azure
Hi, We have the same issue on Azure SQL Data Warehouse. We cannot view the definition of Stored-Procedures. 2024-04-03 11:28:56.172 +03:00 [Error] Unable to obtain CreateScript for sp_WhoIsActiveMicrosoft.Data.SqlClient.SqlException (0x80131904): Catalog view 'triggers' is not supported in this version. at… -
Re: Treat empty strings as NULL results in comparison errors
Comment by yagerlin56 · · Home› Discontinued and Previous Versions› SQL Data Compare Previous VersionsString a = null, it will only save a string type in the stack pointer, but the pointer is not just to any string heap. String a = string. The Empty, in addition to save a string type in the stack pointer, the pointer points to the string data of pile, the Empty string, the string and a = "";Is the same.… -
What is the manual connectionstring format?
-
Re: Upgrading to Visual Studio 2022 17.9.0
Hi Eric, I have upgraded to VS 2022 v 17.9.0 and I am getting below error. It looks to the one you are referring to with 17.8.0 version - https://forum.red-gate.com/discussion/90219/problem-after-update-to-visual-studio-17-8 Anyone else encountered this issue, please? Thanks, Error message: Message = Method not found:… -
Re: Automation Issue
Hi @wkrouth, It looks like you don't have the connection string enclosed in single quotes inside the double quotes. It should look like this with single quotes ' after the equal = sign and before the ending double quote ". "DATACONNECTION='<Connection string>'", that is "DATACONNECTION='Data Source=**********;Initial… -
Re: Using the API how do you turn on Compression.
PackagerEngine Constructor(String,String,String,ExecutionBlock,ExecutionBlock,OutputType,Boolean) Public Function New( _ ByVal templateFolder As String, _ ByVal packageFolder As String, _ ByVal packageName As String, _ ByVal executionBlockSchema As ExecutionBlock, _ ByVal executionBlockData As ExecutionBlock, _ ByVal… -
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…
>1706 results