Skip to main content

Script - Deleting a KDE server from the Database

DECLARE @ServerID INT, @UPD INT

SET @ServerID	= 1 --Server ID To Delete
SET @UPD		= 0 --0 to Select 1 to Delete

-- DOT NOT MODIFY BELOW --
IF @UPD != 1
BEGIN
	SELECT * FROM [KDG].[dbo].[kdgDelivery] where serverID =1
	SELECT * FROM [KDG].[dbo].[kdgDeliveryResource] where serverID =1
	SELECT * FROM [KDG].[dbo].kdgDocument where serverID =1
	SELECT * FROM [KDG].[dbo].kdgEmailDelivery where serverID =1
	SELECT * FROM [KDG].[dbo].kdgEmailRecipient where serverID =1
	SELECT * FROM [KDG].[dbo].kdgPrintDelivery where serverID =1
	SELECT * FROM [KDG].[dbo].kdgRequest where serverID =1
	SELECT * FROM [KDG].[dbo].kdgSaveToDiskDelivery where serverID =1
	SELECT * FROM [KDG].[dbo].kdgServer where ID =1
	SELECT * FROM [KDG].[dbo].kdgServerConfig where serverID =1
END

IF @UPD = 1
BEGIN
	DELETE FROM [KDG].[dbo].[kdgDelivery] where serverID =1
	DELETE FROM [KDG].[dbo].[kdgDeliveryResource] where serverID =1
	DELETE FROM [KDG].[dbo].kdgDocument where serverID =1
	DELETE FROM [KDG].[dbo].kdgEmailDelivery where serverID =1
	DELETE FROM [KDG].[dbo].kdgEmailRecipient where serverID =1
	DELETE FROM [KDG].[dbo].kdgPrintDelivery where serverID =1
	DELETE FROM [KDG].[dbo].kdgRequest where serverID =1
	DELETE FROM [KDG].[dbo].kdgSaveToDiskDelivery where serverID =1
	DELETE FROM [KDG].[dbo].kdgServer where ID =1
	DELETE FROM [KDG].[dbo].kdgServerConfig where serverID =1
END