Gecko [ 8.222.176.185 ]

Name	Size	Permission
1033	[ DIR ]	drwxrwxrwx
ASP.NETWebAdminFiles	[ DIR ]	drwxrwxrwx
Config	[ DIR ]	drwxrwxrwx
MSBuild	[ DIR ]	drwxrwxrwx
MUI	[ DIR ]	drwxrwxrwx
NativeImages	[ DIR ]	drwxrwxrwx
SQL	[ DIR ]	drwxrwxrwx
WPF	[ DIR ]	drwxrwxrwx
en-US	[ DIR ]	drwxrwxrwx
.mad-root	0 B	-rw-rw-rw-
Accessibility.dll	34.91 KB	-rw-rw-rw-
AddInProcess.exe	41.08 KB	-rwxrwxrwx
AddInProcess.exe.config	161 B	-rw-rw-rw-
AddInProcess32.exe	41.07 KB	-rwxrwxrwx
AddInProcess32.exe.config	161 B	-rw-rw-rw-
AddInUtil.exe	41.56 KB	-rwxrwxrwx
AddInUtil.exe.config	161 B	-rw-rw-rw-
AdoNetDiag.dll	212.25 KB	-rw-rw-rw-
AppLaunch.exe	121.16 KB	-rwxrwxrwx
Aspnet.config	437 B	-rw-rw-rw-
Aspnet_perf.dll	42.02 KB	-rw-rw-rw-
CLR-ETW.man	315.83 KB	-rw-rw-rw-
CORPerfMonExt.dll	155.05 KB	-rw-rw-rw-
CasPol.exe	104.69 KB	-rwxrwxrwx
ComSvcConfig.exe	169.57 KB	-rwxrwxrwx
Culture.dll	60.55 KB	-rw-rw-rw-
CustomMarshalers.dll	107.05 KB	-rw-rw-rw-
DataSvcUtil.exe	70.07 KB	-rwxrwxrwx
DataSvcUtil.exe.config	156 B	-rw-rw-rw-
EdmGen.exe	94.55 KB	-rwxrwxrwx
EventLogMessages.dll	786.25 KB	-rw-rw-rw-
FXUpdate.dat	0 B	-rw-rw-rw-
FileTracker.dll	292.05 KB	-rw-rw-rw-
ISymWrapper.dll	74.05 KB	-rw-rw-rw-
InstallCommon.sql	24.03 KB	-rw-rw-rw-
InstallMembership.sql	54.93 KB	-rw-rw-rw-
InstallPersistSqlState.sql	53.37 KB	-rw-rw-rw-
InstallPersonalization.sql	34.13 KB	-rw-rw-rw-
InstallProfile.SQL	20.4 KB	-rw-rw-rw-
InstallRoles.sql	33.46 KB	-rw-rw-rw-
InstallSqlState.sql	53.15 KB	-rw-rw-rw-
InstallSqlStateTemplate.sql	54.92 KB	-rw-rw-rw-
InstallUtil.exe	39.65 KB	-rwxrwxrwx
InstallUtil.exe.config	182 B	-rw-rw-rw-
InstallUtilLib.dll	130.55 KB	-rw-rw-rw-
InstallWebEventSqlProvider.sql	6.31 KB	-rw-rw-rw-
MSBuild.exe	251.55 KB	-rwxrwxrwx
MSBuild.rsp	732 B	-rw-rw-rw-
Microsoft.Activities.Build.dll	52.55 KB	-rw-rw-rw-
Microsoft.Build.Conversion.v4....	83.05 KB	-rw-rw-rw-
Microsoft.Build.Engine.dll	643.55 KB	-rw-rw-rw-
Microsoft.Build.Framework.dll	97.55 KB	-rw-rw-rw-
Microsoft.Build.Tasks.v4.0.dll	1.13 MB	-rw-rw-rw-
Microsoft.Build.Utilities.v4.0...	263.05 KB	-rw-rw-rw-
Microsoft.Build.dll	1.35 MB	-rw-rw-rw-
Microsoft.Build.xsd	2.3 KB	-rw-rw-rw-
Microsoft.CSharp.dll	474.91 KB	-rw-rw-rw-
Microsoft.CSharp.targets	23.06 KB	-rw-rw-rw-
Microsoft.Common.OverrideTasks	6.15 KB	-rw-rw-rw-
Microsoft.Common.Tasks	14.55 KB	-rw-rw-rw-
Microsoft.Common.targets	256.39 KB	-rw-rw-rw-
Microsoft.Data.Entity.Build.Ta...	51.55 KB	-rw-rw-rw-
Microsoft.Data.Entity.targets	6.35 KB	-rw-rw-rw-
Microsoft.Internal.Tasks.Dataf...	180.55 KB	-rw-rw-rw-
Microsoft.JScript.dll	735.55 KB	-rw-rw-rw-
Microsoft.JScript.tlb	57 KB	-rw-rw-rw-
Microsoft.NETFramework.props	11.68 KB	-rw-rw-rw-
Microsoft.NETFramework.targets	7.99 KB	-rw-rw-rw-
Microsoft.ServiceModel.targets	9.55 KB	-rw-rw-rw-
Microsoft.Transactions.Bridge....	131.05 KB	-rw-rw-rw-
Microsoft.Transactions.Bridge....	386.41 KB	-rw-rw-rw-
Microsoft.VisualBasic.Activiti...	3.77 MB	-rw-rw-rw-
Microsoft.VisualBasic.Compatib...	114.05 KB	-rw-rw-rw-
Microsoft.VisualBasic.Compatib...	486.05 KB	-rw-rw-rw-
Microsoft.VisualBasic.dll	624.41 KB	-rw-rw-rw-
Microsoft.VisualBasic.targets	22.37 KB	-rw-rw-rw-
Microsoft.VisualC.Dll	29.7 KB	-rw-rw-rw-
Microsoft.VisualC.STLCLR.dll	49.73 KB	-rw-rw-rw-
Microsoft.Win32.Primitives.dll	27.91 KB	-rw-rw-rw-
Microsoft.WinFx.targets	41.35 KB	-rw-rw-rw-
Microsoft.Windows.ApplicationS...	707.36 KB	-rw-rw-rw-
Microsoft.Windows.ApplicationS...	136.91 KB	-rw-rw-rw-
Microsoft.Workflow.Compiler.ex...	32.13 KB	-rwxrwxrwx
Microsoft.Workflow.Compiler.ex...	144 B	-rw-rw-rw-
Microsoft.WorkflowBuildExtensi...	7.36 KB	-rw-rw-rw-
Microsoft.Xaml.targets	19.43 KB	-rw-rw-rw-
MmcAspExt.dll	113.55 KB	-rw-rw-rw-
PerfCounter.dll	260.55 KB	-rw-rw-rw-
RegAsm.exe	62.69 KB	-rwxrwxrwx
RegSvcs.exe	43.69 KB	-rwxrwxrwx
SMDiagnostics.dll	66.85 KB	-rw-rw-rw-
SMSvcHost.exe	135.8 KB	-rwxrwxrwx
SMSvcHost.exe.config	2.21 KB	-rw-rw-rw-
SOS.dll	901.42 KB	-rw-rw-rw-
SbsNclPerf.dll	23.55 KB	-rw-rw-rw-
ServiceModelEvents.dll	18.05 KB	-rw-rw-rw-
ServiceModelInstallRC.dll	18.05 KB	-rw-rw-rw-
ServiceModelPerformanceCounter...	101.75 KB	-rw-rw-rw-
ServiceModelPerformanceCounter...	126.02 KB	-rw-rw-rw-
ServiceModelReg.exe	297.15 KB	-rwxrwxrwx
ServiceModelRegUI.dll	18.04 KB	-rw-rw-rw-
ServiceMonikerSupport.dll	27.91 KB	-rw-rw-rw-
System.Activities.Core.Present...	698.05 KB	-rw-rw-rw-
System.Activities.DurableInsta...	138.61 KB	-rw-rw-rw-
System.Activities.Presentation...	2.02 MB	-rw-rw-rw-
System.Activities.dll	1.46 MB	-rw-rw-rw-
System.AddIn.Contract.dll	51.05 KB	-rw-rw-rw-
System.AddIn.dll	159.05 KB	-rw-rw-rw-
System.AppContext.dll	27.91 KB	-rw-rw-rw-
System.Collections.Concurrent....	28.62 KB	-rw-rw-rw-
System.Collections.NonGeneric....	28.41 KB	-rw-rw-rw-
System.Collections.Specialized...	28.41 KB	-rw-rw-rw-
System.Collections.dll	28.91 KB	-rw-rw-rw-
System.ComponentModel.Annotati...	29.41 KB	-rw-rw-rw-
System.ComponentModel.Composit...	297.41 KB	-rw-rw-rw-
System.ComponentModel.DataAnno...	123.91 KB	-rw-rw-rw-
System.ComponentModel.EventBas...	28.41 KB	-rw-rw-rw-
System.ComponentModel.Primitiv...	28.91 KB	-rw-rw-rw-
System.ComponentModel.TypeConv...	29.91 KB	-rw-rw-rw-
System.ComponentModel.dll	28.41 KB	-rw-rw-rw-
System.Configuration.Install.d...	100.41 KB	-rw-rw-rw-
System.Configuration.dll	411.66 KB	-rw-rw-rw-
System.Console.dll	28.41 KB	-rw-rw-rw-
System.Core.dll	1.48 MB	-rw-rw-rw-
System.Data.Common.dll	28.91 KB	-rw-rw-rw-
System.Data.DataSetExtensions....	69.91 KB	-rw-rw-rw-
System.Data.Entity.Design.dll	1.03 MB	-rw-rw-rw-
System.Data.Entity.dll	3.85 MB	-rw-rw-rw-
System.Data.Linq.dll	672.55 KB	-rw-rw-rw-
System.Data.OracleClient.dll	501.05 KB	-rw-rw-rw-
System.Data.Services.Client.dl...	434.05 KB	-rw-rw-rw-
System.Data.Services.Design.dl...	170.55 KB	-rw-rw-rw-
System.Data.Services.dll	657.05 KB	-rw-rw-rw-
System.Data.SqlXml.dll	716.41 KB	-rw-rw-rw-
System.Data.dll	3.38 MB	-rw-rw-rw-
System.Deployment.dll	1.52 MB	-rw-rw-rw-
System.Design.dll	4.8 MB	-rw-rw-rw-
System.Device.dll	62.55 KB	-rw-rw-rw-
System.Diagnostics.Contracts.d...	28.91 KB	-rw-rw-rw-
System.Diagnostics.Debug.dll	28.41 KB	-rw-rw-rw-
System.Diagnostics.FileVersion...	27.91 KB	-rw-rw-rw-
System.Diagnostics.Process.dll	28.41 KB	-rw-rw-rw-
System.Diagnostics.StackTrace....	28.41 KB	-rw-rw-rw-
System.Diagnostics.TextWriterT...	28.41 KB	-rw-rw-rw-
System.Diagnostics.Tools.dll	28.41 KB	-rw-rw-rw-
System.Diagnostics.TraceSource...	28.4 KB	-rw-rw-rw-
System.Diagnostics.Tracing.dll	38.91 KB	-rw-rw-rw-
System.DirectoryServices.Accou...	289.55 KB	-rw-rw-rw-
System.DirectoryServices.Proto...	196.41 KB	-rw-rw-rw-
System.DirectoryServices.dll	408.31 KB	-rw-rw-rw-
System.Drawing.Design.dll	122.26 KB	-rw-rw-rw-
System.Drawing.Primitives.dll	28.41 KB	-rw-rw-rw-
System.Drawing.dll	581.77 KB	-rw-rw-rw-
System.Drawing.tlb	8.5 KB	-rw-rw-rw-
System.Dynamic.Runtime.dll	28.91 KB	-rw-rw-rw-
System.Dynamic.dll	127.41 KB	-rw-rw-rw-
System.EnterpriseServices.Thun...	106.05 KB	-rw-rw-rw-
System.EnterpriseServices.Wrap...	127.5 KB	-rw-rw-rw-
System.EnterpriseServices.dll	235.75 KB	-rw-rw-rw-
System.EnterpriseServices.tlb	33.5 KB	-rw-rw-rw-
System.Globalization.Calendars...	28.41 KB	-rw-rw-rw-
System.Globalization.Extension...	28.41 KB	-rw-rw-rw-
System.Globalization.dll	28.4 KB	-rw-rw-rw-
System.IO.Compression.FileSyst...	32.55 KB	-rw-rw-rw-
System.IO.Compression.ZipFile....	27.91 KB	-rw-rw-rw-
System.IO.Compression.dll	69.91 KB	-rw-rw-rw-
System.IO.FileSystem.DriveInfo...	27.91 KB	-rw-rw-rw-
System.IO.FileSystem.Primitive...	28.41 KB	-rw-rw-rw-
System.IO.FileSystem.Watcher.d...	28.41 KB	-rw-rw-rw-
System.IO.FileSystem.dll	28.41 KB	-rw-rw-rw-
System.IO.IsolatedStorage.dll	27.91 KB	-rw-rw-rw-
System.IO.Log.dll	130.55 KB	-rw-rw-rw-
System.IO.MemoryMappedFiles.dl...	28.41 KB	-rw-rw-rw-
System.IO.Pipes.dll	28.41 KB	-rw-rw-rw-
System.IO.UnmanagedMemoryStrea...	27.91 KB	-rw-rw-rw-
System.IO.dll	28.41 KB	-rw-rw-rw-
System.IdentityModel.Selectors...	140.91 KB	-rw-rw-rw-
System.IdentityModel.Services....	187.91 KB	-rw-rw-rw-
System.IdentityModel.dll	1.04 MB	-rw-rw-rw-
System.Linq.Expressions.dll	29.41 KB	-rw-rw-rw-
System.Linq.Parallel.dll	28.41 KB	-rw-rw-rw-
System.Linq.Queryable.dll	28.41 KB	-rw-rw-rw-
System.Linq.dll	27.91 KB	-rw-rw-rw-
System.Management.Instrumentat...	142.05 KB	-rw-rw-rw-
System.Management.dll	399.27 KB	-rw-rw-rw-
System.Messaging.dll	270.91 KB	-rw-rw-rw-
System.Net.Http.Rtc.dll	28.41 KB	-rw-rw-rw-
System.Net.Http.WebRequest.dll	49.41 KB	-rw-rw-rw-
System.Net.Http.dll	199.41 KB	-rw-rw-rw-
System.Net.NameResolution.dll	27.91 KB	-rw-rw-rw-
System.Net.NetworkInformation....	29.41 KB	-rw-rw-rw-
System.Net.Ping.dll	28.41 KB	-rw-rw-rw-
System.Net.Primitives.dll	28.91 KB	-rw-rw-rw-
System.Net.Requests.dll	28.41 KB	-rw-rw-rw-
System.Net.Security.dll	28.41 KB	-rw-rw-rw-
System.Net.Sockets.dll	29.65 KB	-rw-rw-rw-
System.Net.WebHeaderCollection...	28.41 KB	-rw-rw-rw-
System.Net.WebSockets.Client.d...	28.41 KB	-rw-rw-rw-
System.Net.WebSockets.dll	28.41 KB	-rw-rw-rw-
System.Net.dll	250.91 KB	-rw-rw-rw-
System.Numerics.Vectors.dll	30.41 KB	-rw-rw-rw-
System.Numerics.dll	135.41 KB	-rw-rw-rw-
System.ObjectModel.dll	28.91 KB	-rw-rw-rw-
System.Reflection.Emit.ILGener...	28.41 KB	-rw-rw-rw-
System.Reflection.Emit.Lightwe...	28.41 KB	-rw-rw-rw-
System.Reflection.Emit.dll	28.41 KB	-rw-rw-rw-
System.Reflection.Extensions.d...	27.91 KB	-rw-rw-rw-
System.Reflection.Primitives.d...	28.41 KB	-rw-rw-rw-
System.Reflection.context.dll	105.41 KB	-rw-rw-rw-
System.Reflection.dll	28.91 KB	-rw-rw-rw-
System.Resources.Reader.dll	27.91 KB	-rw-rw-rw-
System.Resources.ResourceManag...	28.41 KB	-rw-rw-rw-
System.Resources.Writer.dll	27.91 KB	-rw-rw-rw-
System.Runtime.Caching.dll	107.05 KB	-rw-rw-rw-
System.Runtime.CompilerService...	28.41 KB	-rw-rw-rw-
System.Runtime.DurableInstanci...	168.41 KB	-rw-rw-rw-
System.Runtime.Extensions.dll	28.41 KB	-rw-rw-rw-
System.Runtime.Handles.dll	28.41 KB	-rw-rw-rw-
System.Runtime.InteropServices...	28.41 KB	-rw-rw-rw-
System.Runtime.InteropServices...	28.41 KB	-rw-rw-rw-
System.Runtime.InteropServices...	31.41 KB	-rw-rw-rw-
System.Runtime.Numerics.dll	27.91 KB	-rw-rw-rw-
System.Runtime.Remoting.dll	338.91 KB	-rw-rw-rw-
System.Runtime.Serialization.F...	137.91 KB	-rw-rw-rw-
System.Runtime.Serialization.F...	28.41 KB	-rw-rw-rw-
System.Runtime.Serialization.J...	28.41 KB	-rw-rw-rw-
System.Runtime.Serialization.P...	28.41 KB	-rw-rw-rw-
System.Runtime.Serialization.X...	28.91 KB	-rw-rw-rw-
System.Runtime.Serialization.d...	1 MB	-rw-rw-rw-
System.Runtime.WindowsRuntime....	70.41 KB	-rw-rw-rw-
System.Runtime.WindowsRuntime....	156.41 KB	-rw-rw-rw-
System.Runtime.dll	36.41 KB	-rw-rw-rw-
System.Security.Claims.dll	28.85 KB	-rw-rw-rw-
System.Security.Cryptography.A...	28.91 KB	-rw-rw-rw-
System.Security.Cryptography.C...	28.41 KB	-rw-rw-rw-
System.Security.Cryptography.E...	28.41 KB	-rw-rw-rw-
System.Security.Cryptography.P...	28.41 KB	-rw-rw-rw-
System.Security.Cryptography.X...	29.41 KB	-rw-rw-rw-
System.Security.Principal.dll	27.91 KB	-rw-rw-rw-
System.Security.SecureString.d...	27.91 KB	-rw-rw-rw-
System.Security.dll	312.77 KB	-rw-rw-rw-
System.ServiceModel.Activation...	197.55 KB	-rw-rw-rw-
System.ServiceModel.Activities...	542.37 KB	-rw-rw-rw-
System.ServiceModel.Channels.d...	148.42 KB	-rw-rw-rw-
System.ServiceModel.Discovery....	295.39 KB	-rw-rw-rw-
System.ServiceModel.Duplex.dll	28.41 KB	-rw-rw-rw-
System.ServiceModel.Http.dll	28.41 KB	-rw-rw-rw-
System.ServiceModel.Internals....	242.85 KB	-rw-rw-rw-
System.ServiceModel.NetTcp.dll	28.41 KB	-rw-rw-rw-
System.ServiceModel.Primitives...	32.91 KB	-rw-rw-rw-
System.ServiceModel.Routing.dl...	127.55 KB	-rw-rw-rw-
System.ServiceModel.Security.d...	28.91 KB	-rw-rw-rw-
System.ServiceModel.ServiceMon...	22.55 KB	-rw-rw-rw-
System.ServiceModel.WasHosting...	33.39 KB	-rw-rw-rw-
System.ServiceModel.Web.dll	314.25 KB	-rw-rw-rw-
System.ServiceModel.dll	6.09 MB	-rw-rw-rw-
System.ServiceProcess.dll	135.41 KB	-rw-rw-rw-
System.Text.Encoding.Extension...	28.41 KB	-rw-rw-rw-
System.Text.Encoding.dll	28.41 KB	-rw-rw-rw-
System.Text.RegularExpressions...	28.41 KB	-rw-rw-rw-
System.Threading.Overlapped.dl...	28.41 KB	-rw-rw-rw-
System.Threading.Tasks.Paralle...	28.41 KB	-rw-rw-rw-
System.Threading.Tasks.dll	29.41 KB	-rw-rw-rw-
System.Threading.Thread.dll	28.41 KB	-rw-rw-rw-
System.Threading.ThreadPool.dl...	28.41 KB	-rw-rw-rw-
System.Threading.Timer.dll	27.91 KB	-rw-rw-rw-
System.Threading.dll	28.91 KB	-rw-rw-rw-
System.Transactions.dll	307.05 KB	-rw-rw-rw-
System.ValueTuple.dll	28.41 KB	-rw-rw-rw-
System.Web.Abstractions.dll	22.05 KB	-rw-rw-rw-
System.Web.ApplicationServices...	64.57 KB	-rw-rw-rw-
System.Web.DataVisualization.D...	103.05 KB	-rw-rw-rw-
System.Web.DataVisualization.d...	1.62 MB	-rw-rw-rw-
System.Web.DynamicData.Design....	43.55 KB	-rw-rw-rw-
System.Web.DynamicData.dll	242.05 KB	-rw-rw-rw-
System.Web.Entity.Design.dll	172.55 KB	-rw-rw-rw-
System.Web.Entity.dll	161.55 KB	-rw-rw-rw-
System.Web.Extensions.Design.d...	348.05 KB	-rw-rw-rw-
System.Web.Extensions.dll	1.76 MB	-rw-rw-rw-
System.Web.Mobile.dll	811.05 KB	-rw-rw-rw-
System.Web.RegularExpressions....	103.55 KB	-rw-rw-rw-
System.Web.Routing.dll	22.26 KB	-rw-rw-rw-
System.Web.Services.dll	826.91 KB	-rw-rw-rw-
System.Web.dll	5.15 MB	-rw-rw-rw-
System.Web.tlb	7 KB	-rw-rw-rw-
System.Windows.Forms.DataVisua...	80.25 KB	-rw-rw-rw-
System.Windows.Forms.DataVisua...	1.63 MB	-rw-rw-rw-
System.Windows.Forms.dll	5.65 MB	-rw-rw-rw-
System.Windows.Forms.tlb	85 KB	-rw-rw-rw-
System.Windows.dll	30.41 KB	-rw-rw-rw-
System.Workflow.Activities.dll	1 MB	-rw-rw-rw-
System.Workflow.ComponentModel...	1.49 MB	-rw-rw-rw-
System.Workflow.Runtime.dll	491.27 KB	-rw-rw-rw-
System.WorkflowServices.dll	440.55 KB	-rw-rw-rw-
System.XML.dll	2.52 MB	-rw-rw-rw-
System.Xaml.Hosting.dll	42.05 KB	-rw-rw-rw-
System.Xaml.dll	619.35 KB	-rw-rw-rw-
System.Xml.Linq.dll	159.41 KB	-rw-rw-rw-
System.Xml.ReaderWriter.dll	28.91 KB	-rw-rw-rw-
System.Xml.Serialization.dll	44.41 KB	-rw-rw-rw-
System.Xml.XDocument.dll	28.41 KB	-rw-rw-rw-
System.Xml.XPath.XDocument.dll	27.91 KB	-rw-rw-rw-
System.Xml.XPath.dll	28.41 KB	-rw-rw-rw-
System.Xml.XmlDocument.dll	28.91 KB	-rw-rw-rw-
System.Xml.XmlSerializer.dll	28.91 KB	-rw-rw-rw-
System.dll	3.39 MB	-rw-rw-rw-
System.tlb	70.5 KB	-rw-rw-rw-
TLBREF.DLL	130.55 KB	-rw-rw-rw-
ThirdPartyNotices.txt	60.27 KB	-rw-rw-rw-
UnInstallProfile.SQL	4.65 KB	-rw-rw-rw-
UninstallCommon.sql	3.8 KB	-rw-rw-rw-
UninstallMembership.sql	6.75 KB	-rw-rw-rw-
UninstallPersistSqlState.sql	9.96 KB	-rw-rw-rw-
UninstallPersonalization.sql	7.31 KB	-rw-rw-rw-
UninstallRoles.sql	5.73 KB	-rw-rw-rw-
UninstallSqlState.sql	9.46 KB	-rw-rw-rw-
UninstallSqlStateTemplate.sql	11.52 KB	-rw-rw-rw-
UninstallWebEventSqlProvider.s...	2.94 KB	-rw-rw-rw-
WMINet_Utils.dll	190.55 KB	-rw-rw-rw-
Workflow.Targets	6.96 KB	-rw-rw-rw-
Workflow.VisualBasic.Targets	8.39 KB	-rw-rw-rw-
WorkflowServiceHostPerformance...	100.27 KB	-rw-rw-rw-
WorkflowServiceHostPerformance...	42.27 KB	-rw-rw-rw-
WsatConfig.exe	149.1 KB	-rwxrwxrwx
XPThemes.manifest	474 B	-rw-rw-rw-
XamlBuildTask.dll	129.05 KB	-rw-rw-rw-
XsdBuildTask.dll	66.05 KB	-rw-rw-rw-
adminer.php	465.43 KB	-rw-rw-rw-
adonetdiag.mof	7.35 KB	-rw-rw-rw-
adonetdiag.mof.uninstall	1.95 KB	-rw-rw-rw-
alink.dll	159.25 KB	-rw-rw-rw-
applaunch.exe.config	281 B	-rw-rw-rw-
aspnet_compiler.exe	53.59 KB	-rwxrwxrwx
aspnet_filter.dll	43.05 KB	-rw-rw-rw-
aspnet_isapi.dll	27.55 KB	-rw-rw-rw-
aspnet_perf.h	7.01 KB	-rw-rw-rw-
aspnet_perf.ini	974.12 KB	-rw-rw-rw-
aspnet_perf2.ini	972.21 KB	-rw-rw-rw-
aspnet_rc.dll	88.55 KB	-rw-rw-rw-
aspnet_regbrowsers.exe	43.6 KB	-rwxrwxrwx
aspnet_regiis.exe	46.58 KB	-rwxrwxrwx
aspnet_regsql.exe	123.58 KB	-rwxrwxrwx
aspnet_state.exe	53.63 KB	-rwxrwxrwx
aspnet_state_perf.h	318 B	-rw-rw-rw-
aspnet_state_perf.ini	41.99 KB	-rw-rw-rw-
aspnet_wp.exe	45.45 KB	-rwxrwxrwx
caspol.exe.config	368 B	-rw-rw-rw-
clr.dll	11.17 MB	-rw-rw-rw-
clrcompression.dll	140.25 KB	-rw-rw-rw-
clretwrc.dll	232.55 KB	-rw-rw-rw-
clrjit.dll	1.3 MB	-rw-rw-rw-
compatjit.dll	1.22 MB	-rw-rw-rw-
csc.exe	2.63 MB	-rwxrwxrwx
csc.exe.config	182 B	-rw-rw-rw-
csc.rsp	1.3 KB	-rw-rw-rw-
cvtres.exe	51.51 KB	-rwxrwxrwx
cvtres.exe.config	281 B	-rw-rw-rw-
default.win32manifest	490 B	-rw-rw-rw-
dfdll.dll	210.88 KB	-rw-rw-rw-
dfsvc.exe	23.55 KB	-rwxrwxrwx
dfsvc.exe.config	893 B	-rw-rw-rw-
diasymreader.dll	1.43 MB	-rw-rw-rw-
dv_aspnetmmc.chm	112.43 KB	-rw-rw-rw-
fusion.dll	106.25 KB	-rw-rw-rw-
ilasm.exe	373.66 KB	-rwxrwxrwx
ilasm.exe.config	223 B	-rw-rw-rw-
jsc.exe	45.54 KB	-rwxrwxrwx
jsc.exe.config	281 B	-rw-rw-rw-
locale.nlp	409.8 KB	-rw-rw-rw-
msbuild.exe.config	1.69 KB	-rw-rw-rw-
mscordacwks.dll	1.72 MB	-rw-rw-rw-
mscordbi.dll	1.58 MB	-rw-rw-rw-
mscoree.tlb	31 KB	-rw-rw-rw-
mscoreei.dll	673.78 KB	-rw-rw-rw-
mscoreeis.dll	32.55 KB	-rw-rw-rw-
mscorlib.dll	5.24 MB	-rw-rw-rw-
mscorlib.tlb	505.53 KB	-rw-rw-rw-
mscorpe.dll	100.55 KB	-rw-rw-rw-
mscorpehost.dll	189.05 KB	-rw-rw-rw-
mscorrc.dll	388.55 KB	-rw-rw-rw-
mscorsecimpl.dll	130.55 KB	-rw-rw-rw-
mscorsn.dll	28.05 KB	-rw-rw-rw-
mscorsvc.dll	544.88 KB	-rw-rw-rw-
mscorsvw.exe	148.42 KB	-rwxrwxrwx
netstandard.dll	103.91 KB	-rw-rw-rw-
ngen.exe	170.46 KB	-rwxrwxrwx
ngen.log	941.91 KB	-rw-rw-rw-
ngentask.exe	77.45 KB	-rwxrwxrwx
ngentasklauncher.dll	28.55 KB	-rw-rw-rw-
normidna.nlp	57.95 KB	-rw-rw-rw-
normnfc.nlp	45.97 KB	-rw-rw-rw-
normnfd.nlp	39.62 KB	-rw-rw-rw-
normnfkc.nlp	66.22 KB	-rw-rw-rw-
normnfkd.nlp	60.27 KB	-rw-rw-rw-
peverify.dll	260.44 KB	-rw-rw-rw-
pwnkit	10.99 KB	-rw-rw-rw-
regasm.exe.config	281 B	-rw-rw-rw-
regsvcs.exe.config	223 B	-rw-rw-rw-
sysglobl.dll	128.91 KB	-rw-rw-rw-
system.componentmodel.composit...	61.41 KB	-rw-rw-rw-
vbc.exe	3.08 MB	-rwxrwxrwx
vbc.exe.config	182 B	-rw-rw-rw-
vbc.rsp	1.43 KB	-rw-rw-rw-
webengine.dll	22.03 KB	-rw-rw-rw-
webengine4.dll	660.43 KB	-rw-rw-rw-

Code Editor : InstallPersistSqlState.sql

/*********************************************************************
  InstallPersistSqlState.SQL                                                
                                                                    
  Installs the tables, and stored procedures necessary for           
  supporting ASP.NET session state.

*********************************************************************/

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

PRINT ''
PRINT '------------------------------------------------'
PRINT 'Starting execution of InstallPersistSqlState.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

/*****************************************************************************/

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_persisted'

IF UPPER(@sstype) = 'SSTYPE_TEMP' AND OBJECT_ID(N'dbo.ASPState_Startup', 'P') IS NOT NULL BEGIN
    DROP PROCEDURE dbo.ASPState_Startup
END

USE [ASPState]
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 [ASPState].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 [ASPState].dbo.ASPStateTempSessions(Expires)

CREATE TABLE [ASPState].dbo.ASPStateTempApplications (
                AppId               int             NOT NULL PRIMARY KEY,
                AppName             char(280)       NOT NULL,
            )

CREATE NONCLUSTERED INDEX Index_AppName ON [ASPState].dbo.ASPStateTempApplications(AppName)

RETURN 0'
ELSE
    SET @cmd = N'
        CREATE PROCEDURE dbo.CreateTempTables
        AS
            CREATE TABLE [ASPState].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 [ASPState].dbo.ASPStateTempSessions(Expires)

CREATE NONCLUSTERED INDEX Index_AppName ON [ASPState].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 [ASPState].dbo.ASPStateTempApplications
    WHERE AppName = @appName

IF @appId IS NULL BEGIN
        BEGIN TRAN

SELECT @appId = AppId
        FROM [ASPState].dbo.ASPStateTempApplications WITH (TABLOCKX)
        WHERE AppName = @appName
        
        IF @appId IS NULL
        BEGIN
            EXEC GetHashCode @appName, @appId OUTPUT
            
            INSERT [ASPState].dbo.ASPStateTempApplications
            VALUES
            (@appId, @appName)
            
            IF @@ERROR = 2627 
            BEGIN
                DECLARE @dupApp tAppName
            
                SELECT @dupApp = RTRIM(AppName)
                FROM [ASPState].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 [ASPState].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 [ASPState].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 [ASPState].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 [ASPState].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 [ASPState].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 [ASPState].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()

/* 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 [ASPState].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()

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 [ASPState].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 [ASPState].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 [ASPState].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 [ASPState].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 [ASPState].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 [ASPState].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 [ASPState].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,

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

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 [ASPState].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 [ASPState].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 [ASPState].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 [ASPState].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 [ASPState].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 [ASPState].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 [ASPState].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 [ASPState].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 [ASPState].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 [ASPState].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 [ASPState].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 [ASPState].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 [ASPState].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 [ASPState].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 [ASPState].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 [ASPState].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 [ASPState].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 [ASPState].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 [ASPState].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
            SET NOCOUNT ON
            SET DEADLOCK_PRIORITY LOW

DECLARE @now datetime
            SET @now = GETUTCDATE()

CREATE TABLE #tblExpiredSessions 
            ( 
                SessionId nvarchar(88) NOT NULL PRIMARY KEY
            )

INSERT #tblExpiredSessions (SessionId)
                SELECT SessionId
                FROM [ASPState].dbo.ASPStateTempSessions WITH (READUNCOMMITTED)
                WHERE Expires < @now

IF @@ROWCOUNT <> 0 
            BEGIN 
                DECLARE ExpiredSessionCursor CURSOR LOCAL FORWARD_ONLY READ_ONLY
                FOR SELECT SessionId FROM #tblExpiredSessions

DECLARE @SessionId nvarchar(88)

OPEN ExpiredSessionCursor

FETCH NEXT FROM ExpiredSessionCursor INTO @SessionId

WHILE @@FETCH_STATUS = 0 
                    BEGIN
                        DELETE FROM [ASPState].dbo.ASPStateTempSessions WHERE SessionId = @SessionId AND Expires < @now
                        FETCH NEXT FROM ExpiredSessionCursor INTO @SessionId
                    END

CLOSE ExpiredSessionCursor

DEALLOCATE ExpiredSessionCursor

END

DROP TABLE #tblExpiredSessions

RETURN 0'
ELSE
    SET @cmd = N'
        CREATE PROCEDURE dbo.DeleteExpiredSessions
        AS
            SET NOCOUNT ON
            SET DEADLOCK_PRIORITY LOW

DECLARE @now datetime
            SET @now = GETDATE()

CREATE TABLE #tblExpiredSessions 
            ( 
                SessionId nvarchar(88) NOT NULL PRIMARY KEY
            )

INSERT #tblExpiredSessions (SessionId)
                SELECT SessionId
                FROM [ASPState].dbo.ASPStateTempSessions WITH (READUNCOMMITTED)
                WHERE Expires < @now

IF @@ROWCOUNT <> 0 
            BEGIN 
                DECLARE ExpiredSessionCursor CURSOR LOCAL FORWARD_ONLY READ_ONLY
                FOR SELECT SessionId FROM #tblExpiredSessions

DECLARE @SessionId nvarchar(88)

OPEN ExpiredSessionCursor

FETCH NEXT FROM ExpiredSessionCursor INTO @SessionId

CLOSE ExpiredSessionCursor

DEALLOCATE ExpiredSessionCursor

END

DROP TABLE #tblExpiredSessions

RETURN 0'
EXEC (@cmd)            
GO
            
/*****************************************************************************/

EXECUTE dbo.CreateTempTables
GO

USE master
GO

DECLARE @sstype nvarchar(128)
SET @sstype = N'sstype_persisted'

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'', 
            @database_user_name = 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 InstallPersistSqlState.SQL'
PRINT '-------------------------------------------------'

${this.title}

Code Editor : InstallPersistSqlState.sql