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.140
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
/********************************************************************* InstallSqlState.SQL Installs the tables, and stored procedures necessary for supporting ASP.NET session state. Copyright Microsoft, Inc. All Rights Reserved. *********************************************************************/ SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO PRINT '' PRINT '-----------------------------------------' PRINT 'Starting execution of InstallSqlState.SQL' PRINT '-----------------------------------------' PRINT '--------------------------------------------------' PRINT 'Note: ' PRINT 'Do not run this file manually. ' PRINT 'You should use aspnet_regsql.exe to install ' PRINT 'and uninstall SQL session state. ' PRINT '' PRINT 'Run ''aspnet_regsql.exe -?'' for details. ' PRINT '--------------------------------------------------' GO /*****************************************************************************/ USE master GO /* Create and populate the session state database */ IF DB_ID(N'ASPState') IS NULL BEGIN DECLARE @cmd nvarchar(500) SET @cmd = N'CREATE DATABASE [ASPState]' EXEC(@cmd) END GO /* Drop all tables, startup procedures, stored procedures and types. */ /* Drop the DeleteExpiredSessions_Job */ DECLARE @jobname nvarchar(200) SET @jobname = N'ASPState' + '_Job_DeleteExpiredSessions' -- Delete the [local] job -- We expected to get an error if the job doesn't exist. PRINT 'If the job does not exist, an error from msdb.dbo.sp_delete_job is expected.' EXECUTE msdb.dbo.sp_delete_job @job_name = @jobname GO DECLARE @sstype nvarchar(128) SET @sstype = N'sstype_temp' IF UPPER(@sstype) = 'SSTYPE_TEMP' AND OBJECT_ID(N'dbo.ASPState_Startup', 'P') IS NOT NULL BEGIN DROP PROCEDURE dbo.ASPState_Startup END USE [tempdb] GO IF OBJECT_ID(N'dbo.ASPStateTempSessions','U') IS NOT NULL BEGIN DROP TABLE dbo.ASPStateTempSessions END IF OBJECT_ID(N'dbo.ASPStateTempApplications','U') IS NOT NULL BEGIN DROP TABLE dbo.ASPStateTempApplications END USE [ASPState] GO IF (EXISTS (SELECT name FROM sysobjects WHERE (name = N'GetMajorVersion') AND (type = 'P'))) DROP PROCEDURE [dbo].GetMajorVersion GO IF (EXISTS (SELECT name FROM sysobjects WHERE (name = N'CreateTempTables') AND (type = 'P'))) DROP PROCEDURE [dbo].CreateTempTables GO IF (EXISTS (SELECT name FROM sysobjects WHERE (name = N'TempGetVersion') AND (type = 'P'))) DROP PROCEDURE [dbo].TempGetVersion GO IF (EXISTS (SELECT name FROM sysobjects WHERE (name = N'GetHashCode') AND (type = 'P'))) DROP PROCEDURE [dbo].GetHashCode GO IF (EXISTS (SELECT name FROM sysobjects WHERE (name = N'TempGetAppID') AND (type = 'P'))) DROP PROCEDURE [dbo].TempGetAppID GO IF (EXISTS (SELECT name FROM sysobjects WHERE (name = N'TempGetStateItem') AND (type = 'P'))) DROP PROCEDURE [dbo].TempGetStateItem GO IF (EXISTS (SELECT name FROM sysobjects WHERE (name = N'TempGetStateItem2') AND (type = 'P'))) DROP PROCEDURE [dbo].TempGetStateItem2 GO IF (EXISTS (SELECT name FROM sysobjects WHERE (name = N'TempGetStateItem3') AND (type = 'P'))) DROP PROCEDURE [dbo].TempGetStateItem3 GO IF (EXISTS (SELECT name FROM sysobjects WHERE (name = N'TempGetStateItemExclusive') AND (type = 'P'))) DROP PROCEDURE [dbo].TempGetStateItemExclusive GO IF (EXISTS (SELECT name FROM sysobjects WHERE (name = N'TempGetStateItemExclusive2') AND (type = 'P'))) DROP PROCEDURE [dbo].TempGetStateItemExclusive2 GO IF (EXISTS (SELECT name FROM sysobjects WHERE (name = N'TempGetStateItemExclusive3') AND (type = 'P'))) DROP PROCEDURE [dbo].TempGetStateItemExclusive3 GO IF (EXISTS (SELECT name FROM sysobjects WHERE (name = N'TempReleaseStateItemExclusive') AND (type = 'P'))) DROP PROCEDURE [dbo].TempReleaseStateItemExclusive GO IF (EXISTS (SELECT name FROM sysobjects WHERE (name = N'TempInsertUninitializedItem') AND (type = 'P'))) DROP PROCEDURE [dbo].TempInsertUninitializedItem GO IF (EXISTS (SELECT name FROM sysobjects WHERE (name = N'TempInsertStateItemShort') AND (type = 'P'))) DROP PROCEDURE [dbo].TempInsertStateItemShort GO IF (EXISTS (SELECT name FROM sysobjects WHERE (name = N'TempInsertStateItemLong') AND (type = 'P'))) DROP PROCEDURE [dbo].TempInsertStateItemLong GO IF (EXISTS (SELECT name FROM sysobjects WHERE (name = N'TempUpdateStateItemShort') AND (type = 'P'))) DROP PROCEDURE [dbo].TempUpdateStateItemShort GO IF (EXISTS (SELECT name FROM sysobjects WHERE (name = N'TempUpdateStateItemShortNullLong') AND (type = 'P'))) DROP PROCEDURE [dbo].TempUpdateStateItemShortNullLong GO IF (EXISTS (SELECT name FROM sysobjects WHERE (name = N'TempUpdateStateItemLong') AND (type = 'P'))) DROP PROCEDURE [dbo].TempUpdateStateItemLong GO IF (EXISTS (SELECT name FROM sysobjects WHERE (name = N'TempUpdateStateItemLongNullShort') AND (type = 'P'))) DROP PROCEDURE [dbo].TempUpdateStateItemLongNullShort GO IF (EXISTS (SELECT name FROM sysobjects WHERE (name = N'TempRemoveStateItem') AND (type = 'P'))) DROP PROCEDURE [dbo].TempRemoveStateItem GO IF (EXISTS (SELECT name FROM sysobjects WHERE (name = N'TempResetTimeout') AND (type = 'P'))) DROP PROCEDURE [dbo].TempResetTimeout GO IF (EXISTS (SELECT name FROM sysobjects WHERE (name = N'DeleteExpiredSessions') AND (type = 'P'))) DROP PROCEDURE [dbo].DeleteExpiredSessions GO IF EXISTS(SELECT name FROM systypes WHERE name ='tSessionId') EXECUTE sp_droptype tSessionId GO IF EXISTS(SELECT name FROM systypes WHERE name ='tAppName') EXECUTE sp_droptype tAppName GO IF EXISTS(SELECT name FROM systypes WHERE name ='tSessionItemShort') EXECUTE sp_droptype tSessionItemShort GO IF EXISTS(SELECT name FROM systypes WHERE name ='tSessionItemLong') EXECUTE sp_droptype tSessionItemLong GO IF EXISTS(SELECT name FROM systypes WHERE name ='tTextPtr') EXECUTE sp_droptype tTextPtr GO /*****************************************************************************/ CREATE PROCEDURE dbo.GetMajorVersion @@ver int OUTPUT AS BEGIN DECLARE @version nchar(100) DECLARE @dot int DECLARE @hyphen int DECLARE @SqlToExec nchar(4000) SELECT @@ver = 7 SELECT @version = @@Version SELECT @hyphen = CHARINDEX(N' - ', @version) IF (NOT(@hyphen IS NULL) AND @hyphen > 0) BEGIN SELECT @hyphen = @hyphen + 3 SELECT @dot = CHARINDEX(N'.', @version, @hyphen) IF (NOT(@dot IS NULL) AND @dot > @hyphen) BEGIN SELECT @version = SUBSTRING(@version, @hyphen, @dot - @hyphen) SELECT @@ver = CONVERT(int, @version) END END END GO /*****************************************************************************/ USE [ASPState] /* Find out the version */ DECLARE @ver int EXEC dbo.GetMajorVersion @@ver=@ver OUTPUT DECLARE @cmd nchar(4000) IF (@ver >= 8) SET @cmd = N' CREATE PROCEDURE dbo.CreateTempTables AS CREATE TABLE [tempdb].dbo.ASPStateTempSessions ( SessionId nvarchar(88) NOT NULL PRIMARY KEY, Created datetime NOT NULL DEFAULT GETUTCDATE(), Expires datetime NOT NULL, LockDate datetime NOT NULL, LockDateLocal datetime NOT NULL, LockCookie int NOT NULL, Timeout int NOT NULL, Locked bit NOT NULL, SessionItemShort VARBINARY(7000) NULL, SessionItemLong image NULL, Flags int NOT NULL DEFAULT 0, ) CREATE NONCLUSTERED INDEX Index_Expires ON [tempdb].dbo.ASPStateTempSessions(Expires) CREATE TABLE [tempdb].dbo.ASPStateTempApplications ( AppId int NOT NULL PRIMARY KEY, AppName char(280) NOT NULL, ) CREATE NONCLUSTERED INDEX Index_AppName ON [tempdb].dbo.ASPStateTempApplications(AppName) RETURN 0' ELSE SET @cmd = N' CREATE PROCEDURE dbo.CreateTempTables AS CREATE TABLE [tempdb].dbo.ASPStateTempSessions ( SessionId nvarchar(88) NOT NULL PRIMARY KEY, Created datetime NOT NULL DEFAULT GETDATE(), Expires datetime NOT NULL, LockDate datetime NOT NULL, LockCookie int NOT NULL, Timeout int NOT NULL, Locked bit NOT NULL, SessionItemShort VARBINARY(7000) NULL, SessionItemLong image NULL, Flags int NOT NULL DEFAULT 0, ) CREATE NONCLUSTERED INDEX Index_Expires ON [tempdb].dbo.ASPStateTempSessions(Expires) CREATE TABLE [tempdb].dbo.ASPStateTempApplications ( AppId int NOT NULL PRIMARY KEY, AppName char(280) NOT NULL, ) CREATE NONCLUSTERED INDEX Index_AppName ON [tempdb].dbo.ASPStateTempApplications(AppName) RETURN 0' EXEC (@cmd) GO /*****************************************************************************/ EXECUTE sp_addtype tSessionId, 'nvarchar(88)', 'NOT NULL' GO EXECUTE sp_addtype tAppName, 'varchar(280)', 'NOT NULL' GO EXECUTE sp_addtype tSessionItemShort, 'varbinary(7000)' GO EXECUTE sp_addtype tSessionItemLong, 'image' GO EXECUTE sp_addtype tTextPtr, 'varbinary(16)' GO /*****************************************************************************/ CREATE PROCEDURE dbo.TempGetVersion @ver char(10) OUTPUT AS SELECT @ver = "2" RETURN 0 GO /*****************************************************************************/ CREATE PROCEDURE dbo.GetHashCode @input tAppName, @hash int OUTPUT AS /* This sproc is based on this C# hash function: int GetHashCode(string s) { int hash = 5381; int len = s.Length; for (int i = 0; i < len; i++) { int c = Convert.ToInt32(s[i]); hash = ((hash << 5) + hash) ^ c; } return hash; } However, SQL 7 doesn't provide a 32-bit integer type that allows rollover of bits, we have to divide our 32bit integer into the upper and lower 16 bits to do our calculation. */ DECLARE @hi_16bit int DECLARE @lo_16bit int DECLARE @hi_t int DECLARE @lo_t int DECLARE @len int DECLARE @i int DECLARE @c int DECLARE @carry int SET @hi_16bit = 0 SET @lo_16bit = 5381 SET @len = DATALENGTH(@input) SET @i = 1 WHILE (@i <= @len) BEGIN SET @c = ASCII(SUBSTRING(@input, @i, 1)) /* Formula: hash = ((hash << 5) + hash) ^ c */ /* hash << 5 */ SET @hi_t = @hi_16bit * 32 /* high 16bits << 5 */ SET @hi_t = @hi_t & 0xFFFF /* zero out overflow */ SET @lo_t = @lo_16bit * 32 /* low 16bits << 5 */ SET @carry = @lo_16bit & 0x1F0000 /* move low 16bits carryover to hi 16bits */ SET @carry = @carry / 0x10000 /* >> 16 */ SET @hi_t = @hi_t + @carry SET @hi_t = @hi_t & 0xFFFF /* zero out overflow */ /* + hash */ SET @lo_16bit = @lo_16bit + @lo_t SET @hi_16bit = @hi_16bit + @hi_t + (@lo_16bit / 0x10000) /* delay clearing the overflow */ /* ^c */ SET @lo_16bit = @lo_16bit ^ @c /* Now clear the overflow bits */ SET @hi_16bit = @hi_16bit & 0xFFFF SET @lo_16bit = @lo_16bit & 0xFFFF SET @i = @i + 1 END /* Do a sign extension of the hi-16bit if needed */ IF (@hi_16bit & 0x8000 <> 0) SET @hi_16bit = 0xFFFF0000 | @hi_16bit /* Merge hi and lo 16bit back together */ SET @hi_16bit = @hi_16bit * 0x10000 /* << 16 */ SET @hash = @hi_16bit | @lo_16bit RETURN 0 GO /*****************************************************************************/ DECLARE @cmd nchar(4000) SET @cmd = N' CREATE PROCEDURE dbo.TempGetAppID @appName tAppName, @appId int OUTPUT AS SET @appName = LOWER(@appName) SET @appId = NULL SELECT @appId = AppId FROM [tempdb].dbo.ASPStateTempApplications WHERE AppName = @appName IF @appId IS NULL BEGIN BEGIN TRAN SELECT @appId = AppId FROM [tempdb].dbo.ASPStateTempApplications WITH (TABLOCKX) WHERE AppName = @appName IF @appId IS NULL BEGIN EXEC GetHashCode @appName, @appId OUTPUT INSERT [tempdb].dbo.ASPStateTempApplications VALUES (@appId, @appName) IF @@ERROR = 2627 BEGIN DECLARE @dupApp tAppName SELECT @dupApp = RTRIM(AppName) FROM [tempdb].dbo.ASPStateTempApplications WHERE AppId = @appId RAISERROR(''SQL session state fatal error: hash-code collision between applications ''''%s'''' and ''''%s''''. Please rename the 1st application to resolve the problem.'', 18, 1, @appName, @dupApp) END END COMMIT END RETURN 0' EXEC(@cmd) GO /*****************************************************************************/ /* Find out the version */ DECLARE @ver int EXEC dbo.GetMajorVersion @@ver=@ver OUTPUT DECLARE @cmd nchar(4000) IF (@ver >= 8) SET @cmd = N' CREATE PROCEDURE dbo.TempGetStateItem @id tSessionId, @itemShort tSessionItemShort OUTPUT, @locked bit OUTPUT, @lockDate datetime OUTPUT, @lockCookie int OUTPUT AS DECLARE @textptr AS tTextPtr DECLARE @length AS int DECLARE @now AS datetime SET @now = GETUTCDATE() UPDATE [tempdb].dbo.ASPStateTempSessions SET Expires = DATEADD(n, Timeout, @now), @locked = Locked, @lockDate = LockDateLocal, @lockCookie = LockCookie, @itemShort = CASE @locked WHEN 0 THEN SessionItemShort ELSE NULL END, @textptr = CASE @locked WHEN 0 THEN TEXTPTR(SessionItemLong) ELSE NULL END, @length = CASE @locked WHEN 0 THEN DATALENGTH(SessionItemLong) ELSE NULL END WHERE SessionId = @id IF @length IS NOT NULL BEGIN READTEXT [tempdb].dbo.ASPStateTempSessions.SessionItemLong @textptr 0 @length END RETURN 0' ELSE SET @cmd = N' CREATE PROCEDURE dbo.TempGetStateItem @id tSessionId, @itemShort tSessionItemShort OUTPUT, @locked bit OUTPUT, @lockDate datetime OUTPUT, @lockCookie int OUTPUT AS DECLARE @textptr AS tTextPtr DECLARE @length AS int DECLARE @now AS datetime SET @now = GETDATE() UPDATE [tempdb].dbo.ASPStateTempSessions SET Expires = DATEADD(n, Timeout, @now), @locked = Locked, @lockDate = LockDate, @lockCookie = LockCookie, @itemShort = CASE @locked WHEN 0 THEN SessionItemShort ELSE NULL END, @textptr = CASE @locked WHEN 0 THEN TEXTPTR(SessionItemLong) ELSE NULL END, @length = CASE @locked WHEN 0 THEN DATALENGTH(SessionItemLong) ELSE NULL END WHERE SessionId = @id IF @length IS NOT NULL BEGIN READTEXT [tempdb].dbo.ASPStateTempSessions.SessionItemLong @textptr 0 @length END RETURN 0' EXEC (@cmd) GO /*****************************************************************************/ DECLARE @ver int EXEC dbo.GetMajorVersion @@ver=@ver OUTPUT DECLARE @cmd nchar(4000) IF (@ver >= 8) SET @cmd = N' CREATE PROCEDURE dbo.TempGetStateItem2 @id tSessionId, @itemShort tSessionItemShort OUTPUT, @locked bit OUTPUT, @lockAge int OUTPUT, @lockCookie int OUTPUT AS DECLARE @textptr AS tTextPtr DECLARE @length AS int DECLARE @now AS datetime SET @now = GETUTCDATE() UPDATE [tempdb].dbo.ASPStateTempSessions SET Expires = DATEADD(n, Timeout, @now), @locked = Locked, @lockAge = DATEDIFF(second, LockDate, @now), @lockCookie = LockCookie, @itemShort = CASE @locked WHEN 0 THEN SessionItemShort ELSE NULL END, @textptr = CASE @locked WHEN 0 THEN TEXTPTR(SessionItemLong) ELSE NULL END, @length = CASE @locked WHEN 0 THEN DATALENGTH(SessionItemLong) ELSE NULL END WHERE SessionId = @id IF @length IS NOT NULL BEGIN READTEXT [tempdb].dbo.ASPStateTempSessions.SessionItemLong @textptr 0 @length END RETURN 0' EXEC (@cmd) GO /*****************************************************************************/ /* Find out the version */ DECLARE @ver int EXEC dbo.GetMajorVersion @@ver=@ver OUTPUT DECLARE @cmd nchar(4000) IF (@ver >= 8) SET @cmd = N' CREATE PROCEDURE dbo.TempGetStateItem3 @id tSessionId, @itemShort tSessionItemShort OUTPUT, @locked bit OUTPUT, @lockAge int OUTPUT, @lockCookie int OUTPUT, @actionFlags int OUTPUT AS DECLARE @textptr AS tTextPtr DECLARE @length AS int DECLARE @now AS datetime SET @now = GETUTCDATE() UPDATE [tempdb].dbo.ASPStateTempSessions SET Expires = DATEADD(n, Timeout, @now), @locked = Locked, @lockAge = DATEDIFF(second, LockDate, @now), @lockCookie = LockCookie, @itemShort = CASE @locked WHEN 0 THEN SessionItemShort ELSE NULL END, @textptr = CASE @locked WHEN 0 THEN TEXTPTR(SessionItemLong) ELSE NULL END, @length = CASE @locked WHEN 0 THEN DATALENGTH(SessionItemLong) ELSE NULL END, /* If the Uninitialized flag (0x1) if it is set, remove it and return InitializeItem (0x1) in actionFlags */ Flags = CASE WHEN (Flags & 1) <> 0 THEN (Flags & ~1) ELSE Flags END, @actionFlags = CASE WHEN (Flags & 1) <> 0 THEN 1 ELSE 0 END WHERE SessionId = @id IF @length IS NOT NULL BEGIN READTEXT [tempdb].dbo.ASPStateTempSessions.SessionItemLong @textptr 0 @length END RETURN 0' ELSE SET @cmd = N' CREATE PROCEDURE dbo.TempGetStateItem3 @id tSessionId, @itemShort tSessionItemShort OUTPUT, @locked bit OUTPUT, @lockDate datetime OUTPUT, @lockCookie int OUTPUT, @actionFlags int OUTPUT AS DECLARE @textptr AS tTextPtr DECLARE @length AS int DECLARE @now AS datetime SET @now = GETDATE() UPDATE [tempdb].dbo.ASPStateTempSessions SET Expires = DATEADD(n, Timeout, @now), @locked = Locked, @lockDate = LockDate, @lockCookie = LockCookie, @itemShort = CASE @locked WHEN 0 THEN SessionItemShort ELSE NULL END, @textptr = CASE @locked WHEN 0 THEN TEXTPTR(SessionItemLong) ELSE NULL END, @length = CASE @locked WHEN 0 THEN DATALENGTH(SessionItemLong) ELSE NULL END, /* If the Uninitialized flag (0x1) if it is set, remove it and return InitializeItem (0x1) in actionFlags */ Flags = CASE WHEN (Flags & 1) <> 0 THEN (Flags & ~1) ELSE Flags END, @actionFlags = CASE WHEN (Flags & 1) <> 0 THEN 1 ELSE 0 END WHERE SessionId = @id IF @length IS NOT NULL BEGIN READTEXT [tempdb].dbo.ASPStateTempSessions.SessionItemLong @textptr 0 @length END RETURN 0' EXEC (@cmd) GO /*****************************************************************************/ DECLARE @ver int EXEC dbo.GetMajorVersion @@ver=@ver OUTPUT DECLARE @cmd nchar(4000) IF (@ver >= 8) SET @cmd = N' CREATE PROCEDURE dbo.TempGetStateItemExclusive @id tSessionId, @itemShort tSessionItemShort OUTPUT, @locked bit OUTPUT, @lockDate datetime OUTPUT, @lockCookie int OUTPUT AS DECLARE @textptr AS tTextPtr DECLARE @length AS int DECLARE @now AS datetime DECLARE @nowLocal AS datetime SET @now = GETUTCDATE() SET @nowLocal = GETDATE() UPDATE [tempdb].dbo.ASPStateTempSessions SET Expires = DATEADD(n, Timeout, @now), LockDate = CASE Locked WHEN 0 THEN @now ELSE LockDate END, @lockDate = LockDateLocal = CASE Locked WHEN 0 THEN @nowLocal ELSE LockDateLocal END, @lockCookie = LockCookie = CASE Locked WHEN 0 THEN LockCookie + 1 ELSE LockCookie END, @itemShort = CASE Locked WHEN 0 THEN SessionItemShort ELSE NULL END, @textptr = CASE Locked WHEN 0 THEN TEXTPTR(SessionItemLong) ELSE NULL END, @length = CASE Locked WHEN 0 THEN DATALENGTH(SessionItemLong) ELSE NULL END, @locked = Locked, Locked = 1 WHERE SessionId = @id IF @length IS NOT NULL BEGIN READTEXT [tempdb].dbo.ASPStateTempSessions.SessionItemLong @textptr 0 @length END RETURN 0' ELSE SET @cmd = N' CREATE PROCEDURE dbo.TempGetStateItemExclusive @id tSessionId, @itemShort tSessionItemShort OUTPUT, @locked bit OUTPUT, @lockDate datetime OUTPUT, @lockCookie int OUTPUT AS DECLARE @textptr AS tTextPtr DECLARE @length AS int DECLARE @now AS datetime SET @now = GETDATE() UPDATE [tempdb].dbo.ASPStateTempSessions SET Expires = DATEADD(n, Timeout, @now), @lockDate = LockDate = CASE Locked WHEN 0 THEN @now ELSE LockDate END, @lockCookie = LockCookie = CASE Locked WHEN 0 THEN LockCookie + 1 ELSE LockCookie END, @itemShort = CASE Locked WHEN 0 THEN SessionItemShort ELSE NULL END, @textptr = CASE Locked WHEN 0 THEN TEXTPTR(SessionItemLong) ELSE NULL END, @length = CASE Locked WHEN 0 THEN DATALENGTH(SessionItemLong) ELSE NULL END, @locked = Locked, Locked = 1 WHERE SessionId = @id IF @length IS NOT NULL BEGIN READTEXT [tempdb].dbo.ASPStateTempSessions.SessionItemLong @textptr 0 @length END RETURN 0' EXEC (@cmd) GO /*****************************************************************************/ DECLARE @ver int EXEC dbo.GetMajorVersion @@ver=@ver OUTPUT DECLARE @cmd nchar(4000) IF (@ver >= 8) SET @cmd = N' CREATE PROCEDURE dbo.TempGetStateItemExclusive2 @id tSessionId, @itemShort tSessionItemShort OUTPUT, @locked bit OUTPUT, @lockAge int OUTPUT, @lockCookie int OUTPUT AS DECLARE @textptr AS tTextPtr DECLARE @length AS int DECLARE @now AS datetime DECLARE @nowLocal AS datetime SET @now = GETUTCDATE() SET @nowLocal = GETDATE() UPDATE [tempdb].dbo.ASPStateTempSessions SET Expires = DATEADD(n, Timeout, @now), LockDate = CASE Locked WHEN 0 THEN @now ELSE LockDate END, LockDateLocal = CASE Locked WHEN 0 THEN @nowLocal ELSE LockDateLocal END, @lockAge = CASE Locked WHEN 0 THEN 0 ELSE DATEDIFF(second, LockDate, @now) END, @lockCookie = LockCookie = CASE Locked WHEN 0 THEN LockCookie + 1 ELSE LockCookie END, @itemShort = CASE Locked WHEN 0 THEN SessionItemShort ELSE NULL END, @textptr = CASE Locked WHEN 0 THEN TEXTPTR(SessionItemLong) ELSE NULL END, @length = CASE Locked WHEN 0 THEN DATALENGTH(SessionItemLong) ELSE NULL END, @locked = Locked, Locked = 1 WHERE SessionId = @id IF @length IS NOT NULL BEGIN READTEXT [tempdb].dbo.ASPStateTempSessions.SessionItemLong @textptr 0 @length END RETURN 0' EXEC (@cmd) GO /*****************************************************************************/ DECLARE @ver int EXEC dbo.GetMajorVersion @@ver=@ver OUTPUT DECLARE @cmd nchar(4000) IF (@ver >= 8) SET @cmd = N' CREATE PROCEDURE dbo.TempGetStateItemExclusive3 @id tSessionId, @itemShort tSessionItemShort OUTPUT, @locked bit OUTPUT, @lockAge int OUTPUT, @lockCookie int OUTPUT, @actionFlags int OUTPUT AS DECLARE @textptr AS tTextPtr DECLARE @length AS int DECLARE @now AS datetime DECLARE @nowLocal AS datetime SET @now = GETUTCDATE() SET @nowLocal = GETDATE() UPDATE [tempdb].dbo.ASPStateTempSessions SET Expires = DATEADD(n, Timeout, @now), LockDate = CASE Locked WHEN 0 THEN @now ELSE LockDate END, LockDateLocal = CASE Locked WHEN 0 THEN @nowLocal ELSE LockDateLocal END, @lockAge = CASE Locked WHEN 0 THEN 0 ELSE DATEDIFF(second, LockDate, @now) END, @lockCookie = LockCookie = CASE Locked WHEN 0 THEN LockCookie + 1 ELSE LockCookie END, @itemShort = CASE Locked WHEN 0 THEN SessionItemShort ELSE NULL END, @textptr = CASE Locked WHEN 0 THEN TEXTPTR(SessionItemLong) ELSE NULL END, @length = CASE Locked WHEN 0 THEN DATALENGTH(SessionItemLong) ELSE NULL END, @locked = Locked, Locked = 1, /* If the Uninitialized flag (0x1) if it is set, remove it and return InitializeItem (0x1) in actionFlags */ Flags = CASE WHEN (Flags & 1) <> 0 THEN (Flags & ~1) ELSE Flags END, @actionFlags = CASE WHEN (Flags & 1) <> 0 THEN 1 ELSE 0 END WHERE SessionId = @id IF @length IS NOT NULL BEGIN READTEXT [tempdb].dbo.ASPStateTempSessions.SessionItemLong @textptr 0 @length END RETURN 0' ELSE SET @cmd = N' CREATE PROCEDURE dbo.TempGetStateItemExclusive3 @id tSessionId, @itemShort tSessionItemShort OUTPUT, @locked bit OUTPUT, @lockDate datetime OUTPUT, @lockCookie int OUTPUT, @actionFlags int OUTPUT AS DECLARE @textptr AS tTextPtr DECLARE @length AS int DECLARE @now AS datetime SET @now = GETDATE() UPDATE [tempdb].dbo.ASPStateTempSessions SET Expires = DATEADD(n, Timeout, @now), @lockDate = LockDate = CASE Locked WHEN 0 THEN @now ELSE LockDate END, @lockCookie = LockCookie = CASE Locked WHEN 0 THEN LockCookie + 1 ELSE LockCookie END, @itemShort = CASE Locked WHEN 0 THEN SessionItemShort ELSE NULL END, @textptr = CASE Locked WHEN 0 THEN TEXTPTR(SessionItemLong) ELSE NULL END, @length = CASE Locked WHEN 0 THEN DATALENGTH(SessionItemLong) ELSE NULL END, @locked = Locked, Locked = 1, /* If the Uninitialized flag (0x1) if it is set, remove it and return InitializeItem (0x1) in actionFlags */ Flags = CASE WHEN (Flags & 1) <> 0 THEN (Flags & ~1) ELSE Flags END, @actionFlags = CASE WHEN (Flags & 1) <> 0 THEN 1 ELSE 0 END WHERE SessionId = @id IF @length IS NOT NULL BEGIN READTEXT [tempdb].dbo.ASPStateTempSessions.SessionItemLong @textptr 0 @length END RETURN 0' EXEC (@cmd) GO /*****************************************************************************/ DECLARE @ver int EXEC dbo.GetMajorVersion @@ver=@ver OUTPUT DECLARE @cmd nchar(4000) IF (@ver >= 8) SET @cmd = N' CREATE PROCEDURE dbo.TempReleaseStateItemExclusive @id tSessionId, @lockCookie int AS UPDATE [tempdb].dbo.ASPStateTempSessions SET Expires = DATEADD(n, Timeout, GETUTCDATE()), Locked = 0 WHERE SessionId = @id AND LockCookie = @lockCookie RETURN 0' ELSE SET @cmd = N' CREATE PROCEDURE dbo.TempReleaseStateItemExclusive @id tSessionId, @lockCookie int AS UPDATE [tempdb].dbo.ASPStateTempSessions SET Expires = DATEADD(n, Timeout, GETDATE()), Locked = 0 WHERE SessionId = @id AND LockCookie = @lockCookie RETURN 0' EXEC (@cmd) GO /*****************************************************************************/ DECLARE @ver int EXEC dbo.GetMajorVersion @@ver=@ver OUTPUT DECLARE @cmd nchar(4000) IF (@ver >= 8) SET @cmd = N' CREATE PROCEDURE dbo.TempInsertUninitializedItem @id tSessionId, @itemShort tSessionItemShort, @timeout int AS DECLARE @now AS datetime DECLARE @nowLocal AS datetime SET @now = GETUTCDATE() SET @nowLocal = GETDATE() INSERT [tempdb].dbo.ASPStateTempSessions (SessionId, SessionItemShort, Timeout, Expires, Locked, LockDate, LockDateLocal, LockCookie, Flags) VALUES (@id, @itemShort, @timeout, DATEADD(n, @timeout, @now), 0, @now, @nowLocal, 1, 1) RETURN 0' ELSE SET @cmd = N' CREATE PROCEDURE dbo.TempInsertUninitializedItem @id tSessionId, @itemShort tSessionItemShort, @timeout int AS DECLARE @now AS datetime SET @now = GETDATE() INSERT [tempdb].dbo.ASPStateTempSessions (SessionId, SessionItemShort, Timeout, Expires, Locked, LockDate, LockCookie, Flags) VALUES (@id, @itemShort, @timeout, DATEADD(n, @timeout, @now), 0, @now, 1, 1) RETURN 0' EXEC (@cmd) GO /*****************************************************************************/ DECLARE @ver int EXEC dbo.GetMajorVersion @@ver=@ver OUTPUT DECLARE @cmd nchar(4000) IF (@ver >= 8) SET @cmd = N' CREATE PROCEDURE dbo.TempInsertStateItemShort @id tSessionId, @itemShort tSessionItemShort, @timeout int AS DECLARE @now AS datetime DECLARE @nowLocal AS datetime SET @now = GETUTCDATE() SET @nowLocal = GETDATE() INSERT [tempdb].dbo.ASPStateTempSessions (SessionId, SessionItemShort, Timeout, Expires, Locked, LockDate, LockDateLocal, LockCookie) VALUES (@id, @itemShort, @timeout, DATEADD(n, @timeout, @now), 0, @now, @nowLocal, 1) RETURN 0' ELSE SET @cmd = N' CREATE PROCEDURE dbo.TempInsertStateItemShort @id tSessionId, @itemShort tSessionItemShort, @timeout int AS DECLARE @now AS datetime SET @now = GETDATE() INSERT [tempdb].dbo.ASPStateTempSessions (SessionId, SessionItemShort, Timeout, Expires, Locked, LockDate, LockCookie) VALUES (@id, @itemShort, @timeout, DATEADD(n, @timeout, @now), 0, @now, 1) RETURN 0' EXEC (@cmd) GO /*****************************************************************************/ DECLARE @ver int EXEC dbo.GetMajorVersion @@ver=@ver OUTPUT DECLARE @cmd nchar(4000) IF (@ver >= 8) SET @cmd = N' CREATE PROCEDURE dbo.TempInsertStateItemLong @id tSessionId, @itemLong tSessionItemLong, @timeout int AS DECLARE @now AS datetime DECLARE @nowLocal AS datetime SET @now = GETUTCDATE() SET @nowLocal = GETDATE() INSERT [tempdb].dbo.ASPStateTempSessions (SessionId, SessionItemLong, Timeout, Expires, Locked, LockDate, LockDateLocal, LockCookie) VALUES (@id, @itemLong, @timeout, DATEADD(n, @timeout, @now), 0, @now, @nowLocal, 1) RETURN 0' ELSE SET @cmd = N' CREATE PROCEDURE dbo.TempInsertStateItemLong @id tSessionId, @itemLong tSessionItemLong, @timeout int AS DECLARE @now AS datetime SET @now = GETDATE() INSERT [tempdb].dbo.ASPStateTempSessions (SessionId, SessionItemLong, Timeout, Expires, Locked, LockDate, LockCookie) VALUES (@id, @itemLong, @timeout, DATEADD(n, @timeout, @now), 0, @now, 1) RETURN 0' EXEC (@cmd) GO /*****************************************************************************/ DECLARE @ver int EXEC dbo.GetMajorVersion @@ver=@ver OUTPUT DECLARE @cmd nchar(4000) IF (@ver >= 8) SET @cmd = N' CREATE PROCEDURE dbo.TempUpdateStateItemShort @id tSessionId, @itemShort tSessionItemShort, @timeout int, @lockCookie int AS UPDATE [tempdb].dbo.ASPStateTempSessions SET Expires = DATEADD(n, @timeout, GETUTCDATE()), SessionItemShort = @itemShort, Timeout = @timeout, Locked = 0 WHERE SessionId = @id AND LockCookie = @lockCookie RETURN 0' ELSE SET @cmd = N' CREATE PROCEDURE dbo.TempUpdateStateItemShort @id tSessionId, @itemShort tSessionItemShort, @timeout int, @lockCookie int AS UPDATE [tempdb].dbo.ASPStateTempSessions SET Expires = DATEADD(n, @timeout, GETDATE()), SessionItemShort = @itemShort, Timeout = @timeout, Locked = 0 WHERE SessionId = @id AND LockCookie = @lockCookie RETURN 0' EXEC (@cmd) GO /*****************************************************************************/ DECLARE @ver int EXEC dbo.GetMajorVersion @@ver=@ver OUTPUT DECLARE @cmd nchar(4000) IF (@ver >= 8) SET @cmd = N' CREATE PROCEDURE dbo.TempUpdateStateItemShortNullLong @id tSessionId, @itemShort tSessionItemShort, @timeout int, @lockCookie int AS UPDATE [tempdb].dbo.ASPStateTempSessions SET Expires = DATEADD(n, @timeout, GETUTCDATE()), SessionItemShort = @itemShort, SessionItemLong = NULL, Timeout = @timeout, Locked = 0 WHERE SessionId = @id AND LockCookie = @lockCookie RETURN 0' ELSE SET @cmd = N' CREATE PROCEDURE dbo.TempUpdateStateItemShortNullLong @id tSessionId, @itemShort tSessionItemShort, @timeout int, @lockCookie int AS UPDATE [tempdb].dbo.ASPStateTempSessions SET Expires = DATEADD(n, @timeout, GETDATE()), SessionItemShort = @itemShort, SessionItemLong = NULL, Timeout = @timeout, Locked = 0 WHERE SessionId = @id AND LockCookie = @lockCookie RETURN 0' EXEC (@cmd) GO /*****************************************************************************/ DECLARE @ver int EXEC dbo.GetMajorVersion @@ver=@ver OUTPUT DECLARE @cmd nchar(4000) IF (@ver >= 8) SET @cmd = N' CREATE PROCEDURE dbo.TempUpdateStateItemLong @id tSessionId, @itemLong tSessionItemLong, @timeout int, @lockCookie int AS UPDATE [tempdb].dbo.ASPStateTempSessions SET Expires = DATEADD(n, @timeout, GETUTCDATE()), SessionItemLong = @itemLong, Timeout = @timeout, Locked = 0 WHERE SessionId = @id AND LockCookie = @lockCookie RETURN 0' ELSE SET @cmd = N' CREATE PROCEDURE dbo.TempUpdateStateItemLong @id tSessionId, @itemLong tSessionItemLong, @timeout int, @lockCookie int AS UPDATE [tempdb].dbo.ASPStateTempSessions SET Expires = DATEADD(n, @timeout, GETDATE()), SessionItemLong = @itemLong, Timeout = @timeout, Locked = 0 WHERE SessionId = @id AND LockCookie = @lockCookie RETURN 0' EXEC (@cmd) GO /*****************************************************************************/ DECLARE @ver int EXEC dbo.GetMajorVersion @@ver=@ver OUTPUT DECLARE @cmd nchar(4000) IF (@ver >= 8) SET @cmd = N' CREATE PROCEDURE dbo.TempUpdateStateItemLongNullShort @id tSessionId, @itemLong tSessionItemLong, @timeout int, @lockCookie int AS UPDATE [tempdb].dbo.ASPStateTempSessions SET Expires = DATEADD(n, @timeout, GETUTCDATE()), SessionItemLong = @itemLong, SessionItemShort = NULL, Timeout = @timeout, Locked = 0 WHERE SessionId = @id AND LockCookie = @lockCookie RETURN 0' ELSE SET @cmd = N' CREATE PROCEDURE dbo.TempUpdateStateItemLongNullShort @id tSessionId, @itemLong tSessionItemLong, @timeout int, @lockCookie int AS UPDATE [tempdb].dbo.ASPStateTempSessions SET Expires = DATEADD(n, @timeout, GETDATE()), SessionItemLong = @itemLong, SessionItemShort = NULL, Timeout = @timeout, Locked = 0 WHERE SessionId = @id AND LockCookie = @lockCookie RETURN 0' EXEC (@cmd) GO /*****************************************************************************/ DECLARE @cmd nchar(4000) SET @cmd = N' CREATE PROCEDURE dbo.TempRemoveStateItem @id tSessionId, @lockCookie int AS DELETE [tempdb].dbo.ASPStateTempSessions WHERE SessionId = @id AND LockCookie = @lockCookie RETURN 0' EXEC(@cmd) GO /*****************************************************************************/ DECLARE @ver int EXEC dbo.GetMajorVersion @@ver=@ver OUTPUT DECLARE @cmd nchar(4000) IF (@ver >= 8) SET @cmd = N' CREATE PROCEDURE dbo.TempResetTimeout @id tSessionId AS UPDATE [tempdb].dbo.ASPStateTempSessions SET Expires = DATEADD(n, Timeout, GETUTCDATE()) WHERE SessionId = @id RETURN 0' ELSE SET @cmd = N' CREATE PROCEDURE dbo.TempResetTimeout @id tSessionId AS UPDATE [tempdb].dbo.ASPStateTempSessions SET Expires = DATEADD(n, Timeout, GETDATE()) WHERE SessionId = @id RETURN 0' EXEC (@cmd) GO /*****************************************************************************/ DECLARE @ver int EXEC dbo.GetMajorVersion @@ver=@ver OUTPUT DECLARE @cmd nchar(4000) IF (@ver >= 8) SET @cmd = N' CREATE PROCEDURE dbo.DeleteExpiredSessions AS DECLARE @now datetime SET @now = GETUTCDATE() DELETE [tempdb].dbo.ASPStateTempSessions WHERE Expires < @now RETURN 0' ELSE SET @cmd = N' CREATE PROCEDURE dbo.DeleteExpiredSessions AS DECLARE @now datetime SET @now = GETDATE() DELETE [tempdb].dbo.ASPStateTempSessions WHERE Expires < @now RETURN 0' EXEC (@cmd) GO /*****************************************************************************/ EXECUTE dbo.CreateTempTables GO USE master GO DECLARE @sstype nvarchar(128) SET @sstype = N'sstype_temp' IF UPPER(@sstype) = 'SSTYPE_TEMP' BEGIN DECLARE @cmd nchar(4000) SET @cmd = N' /* Create the startup procedure */ CREATE PROCEDURE dbo.ASPState_Startup AS EXECUTE ASPState.dbo.CreateTempTables RETURN 0' EXEC(@cmd) EXECUTE sp_procoption @ProcName='dbo.ASPState_Startup', @OptionName='startup', @OptionValue='true' END /*****************************************************************************/ /* Create the job to delete expired sessions */ -- Add job category -- We expect an error if the category already exists. PRINT 'If the category already exists, an error from msdb.dbo.sp_add_category is expected.' EXECUTE msdb.dbo.sp_add_category @name = N'[Uncategorized (Local)]' GO BEGIN TRANSACTION DECLARE @JobID BINARY(16) DECLARE @ReturnCode int DECLARE @nameT nchar(200) SELECT @ReturnCode = 0 -- Add the job SET @nameT = N'ASPState' + '_Job_DeleteExpiredSessions' EXECUTE @ReturnCode = msdb.dbo.sp_add_job @job_id = @JobID OUTPUT, @job_name = @nameT, @owner_login_name = NULL, @description = N'Deletes expired sessions from the session state database.', @category_name = N'[Uncategorized (Local)]', @enabled = 1, @notify_level_email = 0, @notify_level_page = 0, @notify_level_netsend = 0, @notify_level_eventlog = 0, @delete_level= 0 IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback -- Add the job steps SET @nameT = N'ASPState' + '_JobStep_DeleteExpiredSessions' EXECUTE @ReturnCode = msdb.dbo.sp_add_jobstep @job_id = @JobID, @step_id = 1, @step_name = @nameT, @command = N'EXECUTE DeleteExpiredSessions', @database_name = N'ASPState', @server = N'', @subsystem = N'TSQL', @cmdexec_success_code = 0, @flags = 0, @retry_attempts = 0, @retry_interval = 1, @output_file_name = N'', @on_success_step_id = 0, @on_success_action = 1, @on_fail_step_id = 0, @on_fail_action = 2 IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback EXECUTE @ReturnCode = msdb.dbo.sp_update_job @job_id = @JobID, @start_step_id = 1 IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback -- Add the job schedules SET @nameT = N'ASPState' + '_JobSchedule_DeleteExpiredSessions' EXECUTE @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id = @JobID, @name = @nameT, @enabled = 1, @freq_type = 4, @active_start_date = 20001016, @active_start_time = 0, @freq_interval = 1, @freq_subday_type = 4, @freq_subday_interval = 1, @freq_relative_interval = 0, @freq_recurrence_factor = 0, @active_end_date = 99991231, @active_end_time = 235959 IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback -- Add the Target Servers EXECUTE @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @JobID, @server_name = N'(local)' IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback COMMIT TRANSACTION GOTO EndSave QuitWithRollback: IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION EndSave: GO /*************************************************************/ /*************************************************************/ /*************************************************************/ /*************************************************************/ PRINT '' PRINT '------------------------------------------' PRINT 'Completed execution of InstallSqlState.SQL' PRINT '------------------------------------------'