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