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 = @ServerID
SELECT * FROM [KDG].[dbo].[kdgDeliveryResource] where serverID = @ServerID
SELECT * FROM [KDG].[dbo].kdgDocument where serverID = @ServerID
SELECT * FROM [KDG].[dbo].kdgEmailDelivery where serverID = @ServerID
SELECT * FROM [KDG].[dbo].kdgEmailRecipient where serverID = @ServerID
SELECT * FROM [KDG].[dbo].kdgPrintDelivery where serverID = @ServerID
SELECT * FROM [KDG].[dbo].kdgRequest where serverID = @ServerID
SELECT * FROM [KDG].[dbo].kdgSaveToDiskDelivery where serverID = @ServerID
SELECT * FROM [KDG].[dbo].kdgServer where ID = @ServerID
SELECT * FROM [KDG].[dbo].kdgServerConfig where serverID = @ServerID
END
IF @UPD = 1
BEGIN
DELETE FROM [KDG].[dbo].[kdgDelivery] where serverID = @ServerID
DELETE FROM [KDG].[dbo].[kdgDeliveryResource] where serverID = @ServerID
DELETE FROM [KDG].[dbo].kdgDocument where serverID = @ServerID
DELETE FROM [KDG].[dbo].kdgEmailDelivery where serverID = @ServerID
DELETE FROM [KDG].[dbo].kdgEmailRecipient where serverID = @ServerID
DELETE FROM [KDG].[dbo].kdgPrintDelivery where serverID = @ServerID
DELETE FROM [KDG].[dbo].kdgRequest where serverID = @ServerID
DELETE FROM [KDG].[dbo].kdgSaveToDiskDelivery where serverID = @ServerID
DELETE FROM [KDG].[dbo].kdgServer where ID = @ServerID
DELETE FROM [KDG].[dbo].kdgServerConfig where serverID = @ServerID
END