Skip to content

Instantly share code, notes, and snippets.

@pawelpabich
Last active September 23, 2016 01:33
Show Gist options
  • Save pawelpabich/6d25307f90bc93f9997b0a550724018f to your computer and use it in GitHub Desktop.
Save pawelpabich/6d25307f90bc93f9997b0a550724018f to your computer and use it in GitHub Desktop.
UPDATE [dbo].[Deployment]
SET JSON = REPLACE(JSON, '"$type":"Octopus.Server.Orchestration.Deploy.DeploymentState, Octopus.Server",','')
WHERE JSON LIKE '%"$type":"Octopus.Server.Orchestration.Deploy.DeploymentState, Octopus.Server",%'
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment