Search
-
Re: Clone agent offline
-
Server Groups with only 1 Server
-
Change DataCompare Comparison Key
Discussion by Rawden · · Home› Discontinued and Previous Versions› SQL Comparison SDK Previous VersionsHi, In SQL Data Compare, you have the option of changing the Comparision Key from the primary key to something else. I'm just looking for some help to enable me to do this in the SDK. Would I still create the mappings: dbMappings.CreateMappings(dbSource.Tables, dbDest.Tables) and then change the key afterwards, or would I… -
Re: Rule BP011 (A comparison or expression is using NULL without explicit provision for a NULL value.)
The error is "A comparison or expression is using NULL without explicit provision for a NULL value.", yet in the example posted above (not sure why it has strike out in it), the CASE statement has an explicit check for NULL with WHEN NULL THEN... The case can also have an ELSE condition that should catch everything else,… -
Re: how to add -Dio.netty.native.workdir=[path] in conf file flyway.toml
-
Re: SSMS crashing after upgrade to 3.0.5.7
Comment by James B · · Home› Discontinued and Previous Versions› SQL Source Control Previous VersionsOK, with the same kind of error? Or something else? -
Re: Column Picker Stopped Working for Azure Servers (PaaS)
@hassan_imam - I haven't tried the latest version - this post a from ben at the bottom of this thread seems to indicate there is still an issue that hasn't been resolved though: https://forum.red-gate.com/discussion/90375/anyone-else-have-suggestions-not-working-in-latest-update-of-sql-prompt I don't have the time to… -
Re: Mismatch when using PowerShell API with SQL Monitor
-
CASE
Hi Redgate Team, SQL Prompt formats the following code like below: SET @sql = N'SELECT name FROM sys.databases WHERE 1=1' + CASE WHEN @system_only = 1 THEN ' AND database_id IN (1,2,3,4)' ELSE '' END + CASE WHEN @dblist IS NOT NULL THEN ' AND name IN (' + @dblist + ')' ELSE '' END; The last END should be aligned with CASE… -
Re: SQL Prompt not working
Wow, yeah I tried everything including the checkbox above. I uninstalled and reinstalled everything at least a couple times. Finally, I thought maybe it was still something to do with the connection I had setup to my server. I looked up how to delete it and you just choose the dropdown for the connection and hit the…
>2117 results