leteExpiredSessions' EXEC(@cmd) END /* Obselete stored procedure */ IF (EXISTS (SELECT name FROM [ASPState].dbo.sysobjects WHERE (name = N'DropTempTables') AND (type = 'P'))) BEGIN SET @cmd = N'USE [ASPState] DROP PROCEDURE dbo.DropTempTables' EXEC(@cmd) END /* Obselete stored procedure */ IF (EXISTS (SELECT name FROM [ASPState].dbo.sysobjects WHERE (name = N'ResetData') AND (type = 'P'))) BEGIN SET @cmd = N'USE [ASPState] DROP PROCEDURE dbo.ResetData' EXEC(@cmd) END IF EXISTS(SELECT name FROM [ASPState].dbo.systypes WHERE name ='tSessionId') BEGIN SET @cmd = N'USE [ASPState] EXECUTE sp_droptype tSessionId' EXEC(@cmd) END IF EXISTS(SELECT name FROM [ASPState].dbo.systypes WHERE name ='tAppName') BEGIN SET @cmd = N'USE [ASPState] EXECUTE sp_droptype tAppName' EXEC(@cmd) END IF EXISTS(SELECT name FROM [ASPState].dbo.systypes WHERE name ='tSessionItemShort') BEGIN SET @cmd = N'USE [ASPState] EXECUTE sp_droptype tSessionItemShort' EXEC(@cmd) END IF EXISTS(SELECT name FROM [ASPState].dbo.systypes WHERE name ='tSessionItemLong') BEGIN SET @cmd = N'USE [ASPState] EXECUTE sp_droptype tSessionItemLong' EXEC(@cmd) END IF EXISTS(SELECT name FROM [ASPState].dbo.systypes WHERE name ='tTextPtr') BEGIN SET @cmd = N'USE [ASPState] EXECUTE sp_droptype tTextPtr' EXEC(@cmd) END END /*************************************************************/ /*************************************************************/ /*************************************************************/ /*************************************************************/ PRINT '' PRINT '---------------------------------------------------' PRINT 'Completed execution of UninstallPersistSqlState.SQL' PRINT '---------------------------------------------------'