Windows NT KAMIDAKI 10.0 build 19045 (Windows 10) AMD64
Apache/2.4.58 (Win64) OpenSSL/3.1.3 PHP/8.3.9
Server IP : 192.168.3.16 & Your IP : 216.73.216.52
Domains :
Cant Read [ /etc/named.conf ]
User : SISTEMA
Terminal
Auto Root
Create File
Create Folder
Localroot Suggester
Backdoor Destroyer
Readme
C: /
Windows /
Microsoft.NET /
Framework64 /
v2.0.50727 /
Delete
Unzip
Name
Size
Permission
Date
Action
1033
[ DIR ]
drwxrwxrwx
2023-01-18 02:29
1046
[ DIR ]
drwxrwxrwx
2023-01-18 02:29
ASP.NETWebAdminFiles
[ DIR ]
drwxrwxrwx
2023-01-18 02:29
CONFIG
[ DIR ]
drwxrwxrwx
2023-01-18 02:30
MSBuild
[ DIR ]
drwxrwxrwx
2023-01-18 02:29
MUI
[ DIR ]
drwxrwxrwx
2023-01-18 02:29
RedistList
[ DIR ]
drwxrwxrwx
2023-01-18 02:29
pt-BR
[ DIR ]
drwxrwxrwx
2023-01-18 02:29
Accessibility.dll
10.5
KB
-rw-rw-rw-
2019-11-08 18:44
AdoNetDiag.dll
194.57
KB
-rw-rw-rw-
2019-11-08 18:44
AppLaunch.exe
70.63
KB
-rwxrwxrwx
2019-11-08 18:44
AspNetMMCExt.dll
496
KB
-rw-rw-rw-
2019-11-08 18:44
Aspnet.config
323
B
-rw-rw-rw-
2023-01-18 02:29
Aspnet_perf.dll
40.07
KB
-rw-rw-rw-
2019-11-08 18:44
Aspnet_regsql.exe.config
205
B
-rw-rw-rw-
2023-01-18 02:29
CLR.mof
21.54
KB
-rw-rw-rw-
2019-10-15 18:50
CLR.mof.uninstall
907
B
-rw-rw-rw-
2019-10-15 18:50
CORPerfMonExt.dll
95.07
KB
-rw-rw-rw-
2019-11-08 18:44
CasPol.exe
100
KB
-rwxrwxrwx
2019-11-08 18:44
Culture.dll
31.1
KB
-rw-rw-rw-
2019-11-08 18:44
CustomMarshalers.dll
79
KB
-rw-rw-rw-
2019-11-08 18:44
EventLogMessages.dll
779.07
KB
-rw-rw-rw-
2019-11-08 18:44
IEExec.exe
9.5
KB
-rwxrwxrwx
2019-11-08 18:44
IEExecRemote.dll
8
KB
-rw-rw-rw-
2019-11-08 18:44
IEHost.dll
76
KB
-rw-rw-rw-
2019-11-08 18:44
IIEHost.dll
6.5
KB
-rw-rw-rw-
2019-11-08 18:44
ISymWrapper.dll
87.5
KB
-rw-rw-rw-
2019-11-08 18:44
InstallCommon.sql
24.03
KB
-rw-rw-rw-
2023-01-18 02:29
InstallMembership.sql
54.76
KB
-rw-rw-rw-
2023-01-18 02:29
InstallPersistSqlState.sql
51.12
KB
-rw-rw-rw-
2023-01-18 02:29
InstallPersonalization.sql
34.13
KB
-rw-rw-rw-
2023-01-18 02:29
InstallProfile.SQL
20.4
KB
-rw-rw-rw-
2023-01-18 02:29
InstallRoles.sql
33.46
KB
-rw-rw-rw-
2023-01-18 02:29
InstallSqlState.sql
50.91
KB
-rw-rw-rw-
2023-01-18 02:29
InstallSqlStateTemplate.sql
52.64
KB
-rw-rw-rw-
2023-01-18 02:29
InstallUtil.exe
24
KB
-rwxrwxrwx
2019-11-08 18:44
InstallUtilLib.dll
75.6
KB
-rw-rw-rw-
2019-11-08 18:44
InstallWebEventSqlProvider.sql
6.31
KB
-rw-rw-rw-
2023-01-18 02:29
Ldr64.exe
73.66
KB
-rwxrwxrwx
2019-11-08 18:44
MSBuild.exe
64
KB
-rwxrwxrwx
2019-11-08 18:44
MSBuild.rsp
732
B
-rw-rw-rw-
2023-01-18 02:29
Microsoft.Build.Engine.dll
380
KB
-rw-rw-rw-
2019-11-08 18:44
Microsoft.Build.Framework.dll
36
KB
-rw-rw-rw-
2019-11-08 18:44
Microsoft.Build.Tasks.dll
640
KB
-rw-rw-rw-
2019-11-08 18:44
Microsoft.Build.Utilities.dll
76
KB
-rw-rw-rw-
2019-11-08 18:44
Microsoft.Build.xsd
2.3
KB
-rw-rw-rw-
2023-01-18 02:29
Microsoft.CSharp.targets
9.16
KB
-rw-rw-rw-
2019-10-15 18:50
Microsoft.Common.Tasks
6.68
KB
-rw-rw-rw-
2019-10-15 18:50
Microsoft.Common.targets
174.47
KB
-rw-rw-rw-
2019-10-15 18:50
Microsoft.JScript.dll
732
KB
-rw-rw-rw-
2019-11-08 18:44
Microsoft.JScript.tlb
42
KB
-rw-rw-rw-
2019-11-08 18:44
Microsoft.VisualBasic.dll
644
KB
-rw-rw-rw-
2019-11-08 18:44
Microsoft.VisualBasic.targets
9.8
KB
-rw-rw-rw-
2019-10-15 18:50
Microsoft.VisualC.Dll
5.5
KB
-rw-rw-rw-
2019-11-08 18:44
Microsoft.Vsa.dll
32
KB
-rw-rw-rw-
2019-11-08 18:44
Microsoft.Vsa.tlb
22
KB
-rw-rw-rw-
2019-11-08 18:44
Microsoft.WinFX.targets
44.73
KB
-rw-rw-rw-
2019-10-15 18:51
MmcAspExt.dll
113.07
KB
-rw-rw-rw-
2019-11-08 18:44
PerfCounter.dll
106.6
KB
-rw-rw-rw-
2019-11-08 18:44
RegAsm.exe
48
KB
-rwxrwxrwx
2019-11-08 18:44
RegSvcs.exe
28
KB
-rwxrwxrwx
2019-11-08 18:44
SOS.dll
478.04
KB
-rw-rw-rw-
2024-07-12 03:01
ShFusRes.dll
93.57
KB
-rw-rw-rw-
2019-11-08 18:44
System.Configuration.Install.dll
80
KB
-rw-rw-rw-
2019-11-08 18:44
System.Data.OracleClient.dll
491.5
KB
-rw-rw-rw-
2019-11-08 18:44
System.Data.SqlXml.dll
728
KB
-rw-rw-rw-
2019-11-08 18:44
System.Data.dll
3.01
MB
-rw-rw-rw-
2023-11-30 08:11
System.Deployment.dll
824
KB
-rw-rw-rw-
2019-11-08 18:44
System.Design.dll
4.83
MB
-rw-rw-rw-
2019-11-08 18:44
System.DirectoryServices.Protocols.dll
184
KB
-rw-rw-rw-
2019-11-08 18:44
System.DirectoryServices.dll
392
KB
-rw-rw-rw-
2022-03-01 14:57
System.Drawing.Design.dll
80
KB
-rw-rw-rw-
2019-11-08 18:44
System.Drawing.dll
616
KB
-rw-rw-rw-
2019-11-08 18:44
System.Drawing.tlb
7.5
KB
-rw-rw-rw-
2019-11-08 18:44
System.EnterpriseServices.Thunk.dll
62.07
KB
-rw-rw-rw-
2019-11-08 18:44
System.EnterpriseServices.Wrapper.dll
130
KB
-rw-rw-rw-
2019-11-08 18:44
System.EnterpriseServices.dll
240
KB
-rw-rw-rw-
2019-11-08 18:44
System.EnterpriseServices.tlb
32.5
KB
-rw-rw-rw-
2019-11-08 18:44
System.Management.dll
380
KB
-rw-rw-rw-
2019-11-08 18:44
System.Messaging.dll
252
KB
-rw-rw-rw-
2019-11-08 18:44
System.Runtime.Remoting.dll
296
KB
-rw-rw-rw-
2023-11-30 12:21
System.Runtime.Serialization.Formatters.Soap.dll
128
KB
-rw-rw-rw-
2019-11-08 18:44
System.Security.dll
268
KB
-rw-rw-rw-
2023-01-18 02:29
System.ServiceProcess.dll
116
KB
-rw-rw-rw-
2019-11-08 18:44
System.Transactions.dll
276.5
KB
-rw-rw-rw-
2019-11-08 18:44
System.Web.Mobile.dll
816
KB
-rw-rw-rw-
2019-11-08 18:44
System.Web.RegularExpressions.dll
96
KB
-rw-rw-rw-
2023-09-27 07:33
System.Web.Services.dll
820
KB
-rw-rw-rw-
2019-11-08 18:44
System.Web.dll
5.05
MB
-rw-rw-rw-
2023-09-27 03:52
System.Web.tlb
6
KB
-rw-rw-rw-
2019-11-08 18:44
System.Windows.Forms.dll
4.79
MB
-rw-rw-rw-
2019-11-08 18:44
System.Windows.Forms.tlb
83.5
KB
-rw-rw-rw-
2019-11-08 18:44
System.XML.dll
1.96
MB
-rw-rw-rw-
2019-11-08 18:44
System.configuration.dll
420
KB
-rw-rw-rw-
2023-01-18 02:29
System.dll
3.07
MB
-rw-rw-rw-
2023-11-30 12:25
System.tlb
69.5
KB
-rw-rw-rw-
2019-11-08 18:44
TLBREF.DLL
100.07
KB
-rw-rw-rw-
2019-11-08 18:44
UnInstallProfile.SQL
4.65
KB
-rw-rw-rw-
2023-01-18 02:29
UninstallCommon.sql
3.8
KB
-rw-rw-rw-
2023-01-18 02:29
UninstallMembership.sql
6.75
KB
-rw-rw-rw-
2023-01-18 02:29
UninstallPersistSqlState.sql
9.96
KB
-rw-rw-rw-
2023-01-18 02:29
UninstallPersonalization.sql
7.31
KB
-rw-rw-rw-
2023-01-18 02:29
UninstallRoles.sql
5.73
KB
-rw-rw-rw-
2023-01-18 02:29
UninstallSqlState.sql
9.46
KB
-rw-rw-rw-
2023-01-18 02:29
UninstallSqlStateTemplate.sql
11.52
KB
-rw-rw-rw-
2023-01-18 02:29
UninstallWebEventSqlProvider.sql
2.94
KB
-rw-rw-rw-
2023-01-18 02:29
WMINet_Utils.dll
140.07
KB
-rw-rw-rw-
2019-11-08 18:44
XPThemes.manifest
474
B
-rw-rw-rw-
2019-10-15 18:50
adonetdiag.mof
5.87
KB
-rw-rw-rw-
2019-10-15 18:50
alink.dll
126.57
KB
-rw-rw-rw-
2019-11-08 18:44
aspnet_compiler.exe
32
KB
-rwxrwxrwx
2019-11-08 18:44
aspnet_filter.dll
24.57
KB
-rw-rw-rw-
2019-11-08 18:44
aspnet_isapi.dll
19.07
KB
-rw-rw-rw-
2019-11-08 18:44
aspnet_perf.h
6.38
KB
-rw-rw-rw-
2019-10-15 18:50
aspnet_perf.ini
800.31
KB
-rw-rw-rw-
2019-10-15 18:50
aspnet_perf2.ini
798.5
KB
-rw-rw-rw-
2019-10-15 18:50
aspnet_rc.dll
82.07
KB
-rw-rw-rw-
2019-11-08 18:44
aspnet_regbrowsers.exe
13
KB
-rwxrwxrwx
2024-06-01 09:03
aspnet_regiis.exe
48.05
KB
-rwxrwxrwx
2024-06-01 09:03
aspnet_regsql.exe
100
KB
-rwxrwxrwx
2024-06-01 09:03
aspnet_state.exe
45.12
KB
-rwxrwxrwx
2019-11-08 18:44
aspnet_state_perf.h
318
B
-rw-rw-rw-
2019-10-15 18:50
aspnet_state_perf.ini
38.72
KB
-rw-rw-rw-
2019-10-15 18:50
aspnet_wp.exe
45.43
KB
-rwxrwxrwx
2023-09-27 03:52
big5.nlp
65.16
KB
-rw-rw-rw-
2022-09-18 13:38
bopomofo.nlp
80.25
KB
-rw-rw-rw-
2022-09-18 13:38
caspol.exe.config
181
B
-rw-rw-rw-
2023-01-18 02:29
csc.exe
89.12
KB
-rwxrwxrwx
2019-11-08 18:44
csc.exe.config
221
B
-rw-rw-rw-
2023-01-18 02:29
csc.rsp
976
B
-rw-rw-rw-
2023-01-18 02:29
cscomp.dll
1.89
MB
-rw-rw-rw-
2019-11-08 18:44
cscompmgd.dll
13
KB
-rw-rw-rw-
2019-11-08 18:44
cvtres.exe
40.67
KB
-rwxrwxrwx
2019-11-08 18:44
dfdll.dll
131.07
KB
-rw-rw-rw-
2019-11-08 18:44
dfsvc.exe
5
KB
-rwxrwxrwx
2019-11-08 18:44
diasymreader.dll
781.57
KB
-rw-rw-rw-
2019-11-08 18:44
dv_aspnetmmc.chm
112.43
KB
-rw-rw-rw-
2019-10-15 18:50
dw20.exe
45.13
KB
-rwxrwxrwx
2019-11-08 18:44
fusion.dll
20.57
KB
-rw-rw-rw-
2019-11-08 18:44
ieexec.exe.config
181
B
-rw-rw-rw-
2023-01-18 02:29
ilasm.exe
323.63
KB
-rwxrwxrwx
2019-11-08 18:44
ilasm.exe.config
181
B
-rw-rw-rw-
2023-01-18 02:29
jsc.exe
40
KB
-rwxrwxrwx
2019-11-08 18:44
jsc.exe.config
221
B
-rw-rw-rw-
2023-01-18 02:29
ksc.nlp
114.02
KB
-rw-rw-rw-
2022-09-18 13:38
msbuild.exe.config
559
B
-rw-rw-rw-
2023-01-18 02:29
mscordacwks.dll
1.68
MB
-rw-rw-rw-
2024-07-12 03:01
mscordbc.dll
107.57
KB
-rw-rw-rw-
2019-11-08 18:44
mscordbi.dll
566.57
KB
-rw-rw-rw-
2019-11-08 18:44
mscoree.tlb
28
KB
-rw-rw-rw-
2019-11-08 18:44
mscorie.dll
39.07
KB
-rw-rw-rw-
2019-11-08 18:44
mscorjit.dll
1.5
MB
-rw-rw-rw-
2024-06-01 09:03
mscorld.dll
114.07
KB
-rw-rw-rw-
2019-11-08 18:44
mscorlib.dll
4.43
MB
-rw-rw-rw-
2024-07-12 03:00
mscorlib.tlb
500.88
KB
-rw-rw-rw-
2019-10-15 18:50
mscorpe.dll
166.05
KB
-rw-rw-rw-
2024-06-01 09:03
mscorpjt.dll
9
KB
-rw-rw-rw-
2019-11-08 18:44
mscorrc.dll
337.07
KB
-rw-rw-rw-
2019-11-08 18:44
mscorsec.dll
86.57
KB
-rw-rw-rw-
2019-11-08 18:44
mscorsn.dll
19.57
KB
-rw-rw-rw-
2019-11-08 18:44
mscorsvc.dll
486.07
KB
-rw-rw-rw-
2019-11-08 18:44
mscorsvw.exe
91.12
KB
-rwxrwxrwx
2019-11-08 18:44
mscortim.dll
20.57
KB
-rw-rw-rw-
2019-11-08 18:44
mscorwks.dll
10.14
MB
-rw-rw-rw-
2024-07-12 03:01
ngen.exe
159.18
KB
-rwxrwxrwx
2019-11-08 18:44
normalization.dll
27.07
KB
-rw-rw-rw-
2019-11-08 18:44
normidna.nlp
57.95
KB
-rw-rw-rw-
2022-09-18 13:38
normnfc.nlp
44.72
KB
-rw-rw-rw-
2022-09-18 13:38
normnfd.nlp
38.36
KB
-rw-rw-rw-
2022-09-18 13:38
normnfkc.nlp
64.83
KB
-rw-rw-rw-
2022-09-18 13:38
normnfkd.nlp
58.88
KB
-rw-rw-rw-
2022-09-18 13:38
peverify.dll
207.42
KB
-rw-rw-rw-
2024-06-01 09:03
prc.nlp
81.79
KB
-rw-rw-rw-
2022-09-18 13:38
prcp.nlp
81.79
KB
-rw-rw-rw-
2022-09-18 13:38
regasm.exe.config
181
B
-rw-rw-rw-
2023-01-18 02:29
regsvcs.exe.config
181
B
-rw-rw-rw-
2023-01-18 02:29
shfusion.chm
99.12
KB
-rw-rw-rw-
2019-10-15 18:50
shfusion.dll
114.07
KB
-rw-rw-rw-
2019-11-08 18:44
sortkey.nlp
256
KB
-rw-rw-rw-
2022-09-18 13:38
sorttbls.nlp
19.84
KB
-rw-rw-rw-
2022-09-18 13:38
sysglobl.dll
108
KB
-rw-rw-rw-
2019-11-08 18:44
vbc.exe
1.72
MB
-rwxrwxrwx
2024-06-01 09:03
vbc.exe.config
221
B
-rw-rw-rw-
2023-01-18 02:29
vbc.rsp
1.04
KB
-rw-rw-rw-
2023-01-18 02:29
webengine.dll
732.43
KB
-rw-rw-rw-
2023-09-27 03:52
xjis.nlp
27.63
KB
-rw-rw-rw-
2022-09-18 13:38
Save
Rename
/********************************************************************* UninstallSqlStateTemplate.SQL Uninstalls the tables, and stored procedures used for supporting ASP.NET session state. Copyright Microsoft, Inc. All Rights Reserved. *********************************************************************/ PRINT '' PRINT '---------------------------------------------------' PRINT 'Starting execution of UninstallSqlStateTemplate.SQL' PRINT '---------------------------------------------------' PRINT '' PRINT '--------------------------------------------------' PRINT 'Note: ' PRINT 'This file is included for backward compatibility ' PRINT 'only. You should use aspnet_regsql.exe to install' PRINT 'and uninstall SQL session state. ' PRINT '' PRINT 'Run ''aspnet_regsql.exe -?'' for details. ' PRINT '--------------------------------------------------' GO /* InstallSqlStateTemplate.sql and UninstallSqlStateTemplate.sql are templates files for installing the ASP.NET session state SQL objects on a database other than the default 'ASPState'. To create your own script files based on the template: 1. Create your own script files by coping the two template files. 2. Decide a name for your database (e.g. MyASPStateDB) 3. In your own script files, replace all occurences of "DatabaseNamePlaceHolder" by your database name. 4. Install and uninstall ASP.NET session state SQL objects using your own script files. */ /* Drop all tables, startup procedures, stored procedures and types. */ USE master GO /* Drop the DeleteExpiredSessions_Job */ DECLARE @sstype nvarchar(128) SET @sstype = N'sstype_custom' DECLARE @jobname nvarchar(200) DECLARE @JobID binary(16) SET @jobname = N'DatabaseNamePlaceHolder' + '_Job_DeleteExpiredSessions' SELECT @JobID = job_id FROM msdb.dbo.sysjobs WHERE (name = @jobname) IF (@JobID IS NOT NULL) BEGIN -- Check if the job is a multi-server job IF (EXISTS (SELECT * FROM msdb.dbo.sysjobservers WHERE (job_id = @JobID) AND (server_id <> 0))) BEGIN -- There is, so abort the script RAISERROR (N'Unable to import job ''%s'' since there is already a multi-server job with this name.', 16, 1, @jobname) END ELSE -- Delete the [local] job EXECUTE msdb.dbo.sp_delete_job @job_name = @jobname END IF UPPER(@sstype) = 'SSTYPE_TEMP' AND OBJECT_ID(N'dbo.ASPState_Startup', 'P') IS NOT NULL BEGIN DROP PROCEDURE dbo.ASPState_Startup END DECLARE @cmd nchar(4000) /* Do not need to drop the tables for persisted because ASPState will be dropped */ IF UPPER(@sstype) <> 'SSTYPE_PERSISTED' AND DB_ID(N'tempdb') IS NOT NULL BEGIN IF OBJECT_ID(N'[DatabaseNamePlaceHolder].dbo.ASPStateTempSessions','U') IS NOT NULL BEGIN DROP TABLE [DatabaseNamePlaceHolder].dbo.ASPStateTempSessions END IF OBJECT_ID(N'[DatabaseNamePlaceHolder].dbo.ASPStateTempApplications','U') IS NOT NULL BEGIN DROP TABLE [DatabaseNamePlaceHolder].dbo.ASPStateTempApplications END END IF UPPER(@sstype) <> 'SSTYPE_CUSTOM' BEGIN /* Drop the database containing our sprocs if we are not using custom database */ IF DB_ID(N'DatabaseNamePlaceHolder') IS NOT NULL BEGIN SET @cmd = N'DROP DATABASE [DatabaseNamePlaceHolder]' EXEC(@cmd) END END ELSE IF DB_ID(N'DatabaseNamePlaceHolder') IS NOT NULL BEGIN IF (EXISTS (SELECT name FROM [DatabaseNamePlaceHolder].dbo.sysobjects WHERE (name = N'GetMajorVersion') AND (type = 'P'))) BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] DROP PROCEDURE dbo.GetMajorVersion' EXEC(@cmd) END IF (EXISTS (SELECT name FROM [DatabaseNamePlaceHolder].dbo.sysobjects WHERE (name = N'CreateTempTables') AND (type = 'P'))) BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] DROP PROCEDURE dbo.CreateTempTables' EXEC(@cmd) END IF (EXISTS (SELECT name FROM [DatabaseNamePlaceHolder].dbo.sysobjects WHERE (name = N'TempGetVersion') AND (type = 'P'))) BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] DROP PROCEDURE dbo.TempGetVersion' EXEC(@cmd) END IF (EXISTS (SELECT name FROM [DatabaseNamePlaceHolder].dbo.sysobjects WHERE (name = N'GetHashCode') AND (type = 'P'))) BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] DROP PROCEDURE dbo.GetHashCode' EXEC(@cmd) END IF (EXISTS (SELECT name FROM [DatabaseNamePlaceHolder].dbo.sysobjects WHERE (name = N'TempGetAppID') AND (type = 'P'))) BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] DROP PROCEDURE dbo.TempGetAppID' EXEC(@cmd) END IF (EXISTS (SELECT name FROM [DatabaseNamePlaceHolder].dbo.sysobjects WHERE (name = N'TempGetStateItem') AND (type = 'P'))) BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] DROP PROCEDURE dbo.TempGetStateItem' EXEC(@cmd) END IF (EXISTS (SELECT name FROM [DatabaseNamePlaceHolder].dbo.sysobjects WHERE (name = N'TempGetStateItem2') AND (type = 'P'))) BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] DROP PROCEDURE dbo.TempGetStateItem2' EXEC(@cmd) END IF (EXISTS (SELECT name FROM [DatabaseNamePlaceHolder].dbo.sysobjects WHERE (name = N'TempGetStateItem3') AND (type = 'P'))) BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] DROP PROCEDURE dbo.TempGetStateItem3' EXEC(@cmd) END IF (EXISTS (SELECT name FROM [DatabaseNamePlaceHolder].dbo.sysobjects WHERE (name = N'TempGetStateItemExclusive') AND (type = 'P'))) BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] DROP PROCEDURE dbo.TempGetStateItemExclusive' EXEC(@cmd) END IF (EXISTS (SELECT name FROM [DatabaseNamePlaceHolder].dbo.sysobjects WHERE (name = N'TempGetStateItemExclusive2') AND (type = 'P'))) BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] DROP PROCEDURE dbo.TempGetStateItemExclusive2' EXEC(@cmd) END IF (EXISTS (SELECT name FROM [DatabaseNamePlaceHolder].dbo.sysobjects WHERE (name = N'TempGetStateItemExclusive3') AND (type = 'P'))) BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] DROP PROCEDURE dbo.TempGetStateItemExclusive3' EXEC(@cmd) END IF (EXISTS (SELECT name FROM [DatabaseNamePlaceHolder].dbo.sysobjects WHERE (name = N'TempReleaseStateItemExclusive') AND (type = 'P'))) BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] DROP PROCEDURE dbo.TempReleaseStateItemExclusive' EXEC(@cmd) END IF (EXISTS (SELECT name FROM [DatabaseNamePlaceHolder].dbo.sysobjects WHERE (name = N'TempInsertUninitializedItem') AND (type = 'P'))) BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] DROP PROCEDURE dbo.TempInsertUninitializedItem' EXEC(@cmd) END IF (EXISTS (SELECT name FROM [DatabaseNamePlaceHolder].dbo.sysobjects WHERE (name = N'TempInsertStateItemShort') AND (type = 'P'))) BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] DROP PROCEDURE dbo.TempInsertStateItemShort' EXEC(@cmd) END IF (EXISTS (SELECT name FROM [DatabaseNamePlaceHolder].dbo.sysobjects WHERE (name = N'TempInsertStateItemLong') AND (type = 'P'))) BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] DROP PROCEDURE dbo.TempInsertStateItemLong' EXEC(@cmd) END IF (EXISTS (SELECT name FROM [DatabaseNamePlaceHolder].dbo.sysobjects WHERE (name = N'TempUpdateStateItemShort') AND (type = 'P'))) BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] DROP PROCEDURE dbo.TempUpdateStateItemShort' EXEC(@cmd) END IF (EXISTS (SELECT name FROM [DatabaseNamePlaceHolder].dbo.sysobjects WHERE (name = N'TempUpdateStateItemShortNullLong') AND (type = 'P'))) BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] DROP PROCEDURE dbo.TempUpdateStateItemShortNullLong' EXEC(@cmd) END IF (EXISTS (SELECT name FROM [DatabaseNamePlaceHolder].dbo.sysobjects WHERE (name = N'TempUpdateStateItemLong') AND (type = 'P'))) BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] DROP PROCEDURE dbo.TempUpdateStateItemLong' EXEC(@cmd) END IF (EXISTS (SELECT name FROM [DatabaseNamePlaceHolder].dbo.sysobjects WHERE (name = N'TempUpdateStateItemLongNullShort') AND (type = 'P'))) BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] DROP PROCEDURE dbo.TempUpdateStateItemLongNullShort' EXEC(@cmd) END IF (EXISTS (SELECT name FROM [DatabaseNamePlaceHolder].dbo.sysobjects WHERE (name = N'TempRemoveStateItem') AND (type = 'P'))) BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] DROP PROCEDURE dbo.TempRemoveStateItem' EXEC(@cmd) END IF (EXISTS (SELECT name FROM [DatabaseNamePlaceHolder].dbo.sysobjects WHERE (name = N'TempResetTimeout') AND (type = 'P'))) BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] DROP PROCEDURE dbo.TempResetTimeout' EXEC(@cmd) END IF (EXISTS (SELECT name FROM [DatabaseNamePlaceHolder].dbo.sysobjects WHERE (name = N'DeleteExpiredSessions') AND (type = 'P'))) BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] DROP PROCEDURE dbo.DeleteExpiredSessions' EXEC(@cmd) END /* Obselete stored procedure */ IF (EXISTS (SELECT name FROM [DatabaseNamePlaceHolder].dbo.sysobjects WHERE (name = N'DropTempTables') AND (type = 'P'))) BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] DROP PROCEDURE dbo.DropTempTables' EXEC(@cmd) END /* Obselete stored procedure */ IF (EXISTS (SELECT name FROM [DatabaseNamePlaceHolder].dbo.sysobjects WHERE (name = N'ResetData') AND (type = 'P'))) BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] DROP PROCEDURE dbo.ResetData' EXEC(@cmd) END IF EXISTS(SELECT name FROM [DatabaseNamePlaceHolder].dbo.systypes WHERE name ='tSessionId') BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] EXECUTE sp_droptype tSessionId' EXEC(@cmd) END IF EXISTS(SELECT name FROM [DatabaseNamePlaceHolder].dbo.systypes WHERE name ='tAppName') BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] EXECUTE sp_droptype tAppName' EXEC(@cmd) END IF EXISTS(SELECT name FROM [DatabaseNamePlaceHolder].dbo.systypes WHERE name ='tSessionItemShort') BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] EXECUTE sp_droptype tSessionItemShort' EXEC(@cmd) END IF EXISTS(SELECT name FROM [DatabaseNamePlaceHolder].dbo.systypes WHERE name ='tSessionItemLong') BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] EXECUTE sp_droptype tSessionItemLong' EXEC(@cmd) END IF EXISTS(SELECT name FROM [DatabaseNamePlaceHolder].dbo.systypes WHERE name ='tTextPtr') BEGIN SET @cmd = N'USE [DatabaseNamePlaceHolder] EXECUTE sp_droptype tTextPtr' EXEC(@cmd) END END /*************************************************************/ /*************************************************************/ /*************************************************************/ /*************************************************************/ PRINT '' PRINT '----------------------------------------------------' PRINT 'Completed execution of UninstallSqlStateTemplate.SQL' PRINT '----------------------------------------------------'