Activity overview
Latest activity by JohnnyC3PO
Can you retrieve the Image Name from a clone
Hi,I have some custom PowerShell that deletes and recreates clones on deployments, but due to the size of some of these, I only want to do this if the latest image has changed from the image that w...
The script we're using is one that we've been using for years in automated deployment scripts, and we've just replaced the variables with the specific settings we need for this script. The basic structure is as follows:
ALTER PROCEDURE [dbo].[sp_Name]
(
@ID INT,
@SRC_ID INT
)
AS
SET NOCOUNT ON
DECLARE
@name VARCHAR(300),
@code INT
--Contents of sproc here BEGIN
END
SET NOCOUNT OFF
GO
/ comments
The script we're using is one that we've been using for years in automated deployment scripts, and we've just replaced the variables with the specific settings we need for this script. The basic st...
Issues running ALTER PROCEDURE statements in T-SQL mod scripts
I'm trying to incorporate a SQL script into the image creation process within SQL Clone, however I cannot seem to run an ALTER PROCEDURE statement as we get the following error:
System.Data.SqlClie...
Hi, We're on version 2.4.5.9041 ,and the error from the deployment is: [image]
This works fine as long as the clone has been deployed already to that server so it can be deleted. / comments
Hi, We're on version 2.4.5.9041 ,and the error from the deployment is:
This works fine as long as the clone has been deployed already to that server so it can be deleted.
Automated Script: Check if a Clone exists before deleting it
I'm trialing a Proof of Concept for SQLClone and am in the last stages of automation. Via Octopus Deploy, I'm now provisioning databases however am having issues in cases where the DB in question h...