Activity overview
Latest activity by Mark R
Any scripts folder created by Redgate tools will have a RedGateDatabaseInfo.xml file in it. / comments
Any scripts folder created by Redgate tools will have a RedGateDatabaseInfo.xml file in it.
No, there isn't any way to override the collation of a scripts folder at the command line. If the collation of the scripts folder is not correct, you can change it by editing RedGateDatabaseInfo.xml: [image] / comments
No, there isn't any way to override the collation of a scripts folder at the command line. If the collation of the scripts folder is not correct, you can change it by editing RedGateDatabaseInfo.xml:
BlueBSH said:
To make this more confusing why do I need to trust a server certificate on a server that does not have encryption enabled? There should be no SSL exchange happening if encryption isn't set up or enforced... I get this same problem on a system that has no SSL encryption so there is no cert to trust
As you're not expectingt the connection to be encrypted, could you try adding ;Encrypt=False to the server name? / comments
BlueBSH said:
To make this more confusing why do I need to trust a server certificate on a server that does not have encryption enabled? There should be no SSL exchange happening if encrypti...
Could you try 14.6.0? https://download.red-gate.com/checkforupdates/SQLCompare/SQLCompare_14.6.0.19635.exe
We have updated the connection library (Microsoft.Data.SqlClient) since SQL Compare 14.5.1, so it's worth a shot. / comments
Could you try 14.6.0? https://download.red-gate.com/checkforupdates/SQLCompare/SQLCompare_14.6.0.19635.exe
We have updated the connection library (Microsoft.Data.SqlClient) since SQL Compare 14.5.1...
Huh. If the same problem happens when on the server itself, it can't possibly be the issue from that Microsoft doc as that's about running things on *different* Windows versions! What authentication method are you using?
/ comments
Huh. If the same problem happens when on the server itself, it can't possibly be the issue from that Microsoft doc as that's about running things on *different* Windows versions!What authentication...
Is the connection - on the local machine - over the LAN - over the internet?
/ comments
Is the connection- on the local machine- over the LAN- over the internet?
SQL Data Compare uses the sp_table_validation stored procedure. / comments
SQL Data Compare uses the sp_table_validation stored procedure.
dross0001 - you can find the SQL Search 3.2.7 installer here: ftp://support.red-gate.com/patches/SQLSearch/31May2019/SQLSearch.exe / comments
dross0001 - you can find the SQL Search 3.2.7 installer here: ftp://support.red-gate.com/patches/SQLSearch/31May2019/SQLSearch.exe
If you're not able to update SQL Prompt, you'll need to downgrade SQL Search to 3.2.7 and disable auto update of SQL Search. SQL Search 3.2.7 will prompt before updating to 3.3.0 or later, so if you: - uninstall SQL Search 3.4.0 - install SQL Search 3.2.7 - run SSMS, open SQL Search, and choose No when SQL Search asks if you want to update - in the Help menu in the SQL Search pane, untick "Enable auto-updates" then you should be able to use both SQL Search and SQL Prompt again. Unfortunately, if different SSMS plugins use different versions of DLLs you can end up with this sort of conflict [image]
/ comments
If you're not able to update SQL Prompt, you'll need to downgrade SQL Search to 3.2.7 and disable auto update of SQL Search. SQL Search 3.2.7 will prompt before updating to 3.3.0 or later, so if yo...
I'm afraid this isn't a feature in SQL Search currently. / comments
I'm afraid this isn't a feature in SQL Search currently.