Hi,
I modified the script to work with 7.5, I tested it and went fine. Here the code
USE ProcessManager
DECLARE @Process_ID nvarchar(50),
@Session_ID nvarchar(36),
@Task_ID nvarchar (36)
SET @Process_ID = 'IM-XXXXXX' --Specific Process ID to be deleted.
SET @Session_ID = (SELECT SessionID FROM ReportProcess WHERE ReportProcessID = @Process_ID)
DECLARE cur_TaskID CURSOR FOR
SELECT TaskID
FROM Task
WHERE SessionID = @Session_ID
DELETE FROM ReportProcess WHERE SessionID = @Session_ID
DELETE FROM ReportProcessStatusHistory WHERE SessionID = @Session_ID
OPEN cur_TaskID
FETCH NEXT FROM cur_TaskID INTO @Task_ID
WHILE (@@FETCH_STATUS=0)
BEGIN
delete from TaskAssignment
where TaskID = @Task_ID
FETCH NEXT FROM cur_TaskID INTO @Task_ID
End
DELETE FROM Task WHERE SessionID = @Session_ID
DELETE FROM [Messages] WHERE MessageID = @Session_ID
DELETE from ImIncidentTicket where SessionId = @Session_ID
CLOSE cur_TaskID
DEALLOCATE cur_TaskID
Any comment?