Как обновить 2 значение в 2 разных баз данных

DECLARE @oldName nvarchar(30), @NewName nvarchar(30)
 
SET @oldName = N'Значение'
SET @NewName = N'Значение2'
 
UPDATE T2
SET T2.Name = @NewName, T1.Name=@NewName
 
FROM [DB1].[dbo].[ResultName] T1
INNER JOIN [DB2].[dbo].[ResultName] T2 ON T1.ID=T2.ID
 
WHERE T2.[Name] = @oldName 
AND T2.DeleteFlag=0

DECLARE @oldName nvarchar(30)   , @NewName nvarchar(30),@nameID INT
DECLARE @dt2Date datetime2(0) = GETDATE();
 
SET @oldName='name'
SET @NewName='name'
 
IF OBJECT_ID(N'RenameName', N'U') IS NULL
BEGIN
  EXEC ('CREATE TABLE dnworld.dbo.RenameName (CreateDate datetime2(0) NOT NULL, Name nvarchar(30) NOT NULL, OldName nvarchar(30) NOT NULL)');
END
 
SET @nameID =(SELECT [ID] FROM [DB1].[dbo].[ResultName] WHERE [Name]=@oldName)
 
UPDATE TOP(1) [DB2].[dbo].[ResultName] SET [Name]=@NewName WHERE [ID]=@nameID
UPDATE TOP(1) [DB1].[dbo].[ResultName] SET [Name]=@NewName WHERE [ID]=@nameID AND [DeleteFlag]=0
 
 
INSERT dnworld.dbo.RenameName (CreateDate, Name, OldName)
VALUES (@dt2Date, @NewName, @oldName)