Activity overview
Latest activity by james.strath
RedGate.SQLCompare.UI.exe C:\Program Files (x86)\Red Gate\SQL Compare 15 15.4.10.27977+6a233340b701adde9321bff7be3c47314fc3b733 4.0.30319.0 False Thanks Christian- apologies, I should know by now that it would be useful to include these each time on a ticket! - Also that would prompt me to do what i normally do when i encounter a possible issue and update the software to see if it's been resolved already. I will probably update later today i have a simple proc on both databases [image] i make a trivial change to force a difference [image] I go to deploy and the script include my intended change but as a consequence changes the first line [image] so following the deployment it shows as no difference between the two databases [image] but an unintended change has occurred - which means i have to correct it manually afterwards (which is tedious when it surprises you and amends multiple items) and it shows up as every object different when using a different compare tool (Eg devops) [image] script for the simple proc to be precisely like mine - but it happens on any proc, object you write CREATE OR ALTER PROC [dbo].[proc] AS ;BEGIN ;SET NOCOUNT ON ;BEGIN TRY ;DECLARE @this_proc_name sysname = (CONCAT((QUOTENAME(OBJECT_SCHEMA_NAME(@@PROCID))), (CHAR(46)), (QUOTENAME(OBJECT_NAME(@@PROCID))))) ;DECLARE @RC INT = (0) ;RAISERROR(@this_proc_name, 10, 0)WITH NOWAIT ;END_OF_QUERY: ;RETURN(@RC) END TRY BEGIN CATCH ;DECLARE @ErrorMessage NVARCHAR(MAX) = (ERROR_MESSAGE()) ;RAISERROR(@ErrorMessage, 16, -1) ;RETURN(ERROR_NUMBER()) END CATCH END --of sp GO / comments
RedGate.SQLCompare.UI.exeC:\Program Files (x86)\Red Gate\SQL Compare 1515.4.10.27977+6a233340b701adde9321bff7be3c47314fc3b7334.0.30319.0FalseThanks Christian- apologies, I should know by now that ...
Deploy making undesired change to code where there wasn't a difference
when i create or alter an object and have the object name on the following line to the create or alter part on both sides of the comparison identically once i deploy the change (which is further wi...