matt40k · May 7, 2018 07:43
diff --git a/renameSql.sql b/renameSql.sql
 sp_dropserver <old_name>;  
 GO  
 sp_addserver <new_name>, local;  
 GO  
diff --git a/renameSQLjobserver.sql b/renameSQLjobserver.sql
 DECLARE
    @oldname varchar(255) = '<old_name>'
   ,@newname varchar(255) = '<new_name>';
 
 UPDATE
   msdb.dbo.sysjobsteps
 SET
   command = REPLACE(command, @oldname, @newname)
 WHERE
   command LIKE '%'+@oldname+'%';
diff --git a/selectServername.sql b/selectServername.sql
 select @@servername
diff --git a/updateOctopusNode.sql b/updateOctopusNode.sql
 DECLARE
    @oldname varchar(255) = '<old_name>'
   ,@newname varchar(255) = '<new_name>';
 UPDATE
   OctopusDeploy.dbo.OctopusServerNode
 SET
   name = @newname
 WHERE
   name = @oldname;
	DECLARE
	@oldname varchar(255) = '<old_name>'
	,@newname varchar(255) = '<new_name>';

	UPDATE
	msdb.dbo.sysjobsteps
	SET
	command = REPLACE(command, @oldname, @newname)
	WHERE
	command LIKE '%'+@oldname+'%';