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