Gecko [ edgpens.lpkmn.gov.my ]

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
Accessibility.dll	35.17 KB	-rw-rw-rw-
AddInProcess.exe	41.18 KB	-rwxrwxrwx
AddInProcess.exe.config	161 B	-rw-rw-rw-
AddInProcess32.exe	41.19 KB	-rwxrwxrwx
AddInProcess32.exe.config	161 B	-rw-rw-rw-
AddInUtil.exe	41.66 KB	-rwxrwxrwx
AddInUtil.exe.config	161 B	-rw-rw-rw-
AdoNetDiag.dll	169.67 KB	-rw-rw-rw-
AppLaunch.exe	96.66 KB	-rwxrwxrwx
Aspnet.config	437 B	-rw-rw-rw-
Aspnet_perf.dll	35.94 KB	-rw-rw-rw-
CLR-ETW.man	313.6 KB	-rw-rw-rw-
CORPerfMonExt.dll	125.68 KB	-rw-rw-rw-
CasPol.exe	105.16 KB	-rwxrwxrwx
ComSvcConfig.exe	169.68 KB	-rwxrwxrwx
Culture.dll	53.66 KB	-rw-rw-rw-
CustomMarshalers.dll	93.69 KB	-rw-rw-rw-
DataSvcUtil.exe	69.67 KB	-rwxrwxrwx
DataSvcUtil.exe.config	156 B	-rw-rw-rw-
EdmGen.exe	94.65 KB	-rwxrwxrwx
EventLogMessages.dll	786.7 KB	-rw-rw-rw-
FXUpdate.dat	0 B	-rw-rw-rw-
FileTracker.dll	215.67 KB	-rw-rw-rw-
ISymWrapper.dll	69.67 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	40.17 KB	-rwxrwxrwx
InstallUtil.exe.config	182 B	-rw-rw-rw-
InstallUtilLib.dll	66.69 KB	-rw-rw-rw-
InstallWebEventSqlProvider.sql	6.31 KB	-rw-rw-rw-
MSBuild.exe	255.8 KB	-rwxrwxrwx
MSBuild.rsp	732 B	-rw-rw-rw-
Microsoft.Activities.Build.dll	52.23 KB	-rw-rw-rw-
Microsoft.Build.Conversion.v4....	83.25 KB	-rw-rw-rw-
Microsoft.Build.Engine.dll	643.72 KB	-rw-rw-rw-
Microsoft.Build.Framework.dll	97.73 KB	-rw-rw-rw-
Microsoft.Build.Tasks.v4.0.dll	1.12 MB	-rw-rw-rw-
Microsoft.Build.Utilities.v4.0...	263.24 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	475.19 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.26 KB	-rw-rw-rw-
Microsoft.Data.Entity.targets	6.35 KB	-rw-rw-rw-
Microsoft.Internal.Tasks.Dataf...	180.76 KB	-rw-rw-rw-
Microsoft.JScript.dll	736.2 KB	-rw-rw-rw-
Microsoft.JScript.tlb	57.5 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....	128.26 KB	-rw-rw-rw-
Microsoft.Transactions.Bridge....	386.76 KB	-rw-rw-rw-
Microsoft.VisualBasic.Activiti...	2.78 MB	-rw-rw-rw-
Microsoft.VisualBasic.Compatib...	114.29 KB	-rw-rw-rw-
Microsoft.VisualBasic.Compatib...	486.27 KB	-rw-rw-rw-
Microsoft.VisualBasic.dll	625.22 KB	-rw-rw-rw-
Microsoft.VisualBasic.targets	22.78 KB	-rw-rw-rw-
Microsoft.VisualC.Dll	29.69 KB	-rw-rw-rw-
Microsoft.VisualC.STLCLR.dll	49.73 KB	-rw-rw-rw-
Microsoft.WinFx.targets	41.22 KB	-rw-rw-rw-
Microsoft.Windows.ApplicationS...	707.35 KB	-rw-rw-rw-
Microsoft.Windows.ApplicationS...	137.38 KB	-rw-rw-rw-
Microsoft.Workflow.Compiler.ex...	32.23 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	105.66 KB	-rw-rw-rw-
PerfCounter.dll	210.67 KB	-rw-rw-rw-
RegAsm.exe	63.15 KB	-rwxrwxrwx
RegSvcs.exe	44.16 KB	-rwxrwxrwx
SMDiagnostics.dll	67.47 KB	-rw-rw-rw-
SMSvcHost.exe	135.8 KB	-rwxrwxrwx
SMSvcHost.exe.config	2.21 KB	-rw-rw-rw-
SOS.dll	719.91 KB	-rw-rw-rw-
SbsNclPerf.dll	23.16 KB	-rw-rw-rw-
ServiceModelEvents.dll	18.7 KB	-rw-rw-rw-
ServiceModelInstallRC.dll	18.71 KB	-rw-rw-rw-
ServiceModelPerformanceCounter...	89.25 KB	-rw-rw-rw-
ServiceModelPerformanceCounter...	126.02 KB	-rw-rw-rw-
ServiceModelReg.exe	216.69 KB	-rwxrwxrwx
ServiceModelRegUI.dll	18.7 KB	-rw-rw-rw-
ServiceMonikerSupport.dll	22.94 KB	-rw-rw-rw-
System.Activities.Core.Present...	690.77 KB	-rw-rw-rw-
System.Activities.DurableInsta...	138.8 KB	-rw-rw-rw-
System.Activities.Presentation...	2 MB	-rw-rw-rw-
System.Activities.dll	1.46 MB	-rw-rw-rw-
System.AddIn.Contract.dll	51.21 KB	-rw-rw-rw-
System.AddIn.dll	159.18 KB	-rw-rw-rw-
System.Collections.Concurrent....	28.77 KB	-rw-rw-rw-
System.Collections.dll	29.2 KB	-rw-rw-rw-
System.ComponentModel.Annotati...	29.79 KB	-rw-rw-rw-
System.ComponentModel.Composit...	298.29 KB	-rw-rw-rw-
System.ComponentModel.DataAnno...	123.31 KB	-rw-rw-rw-
System.ComponentModel.EventBas...	28.81 KB	-rw-rw-rw-
System.ComponentModel.dll	28.72 KB	-rw-rw-rw-
System.Configuration.Install.d...	100.26 KB	-rw-rw-rw-
System.Configuration.dll	410.66 KB	-rw-rw-rw-
System.Core.dll	1.48 MB	-rw-rw-rw-
System.Data.DataSetExtensions....	70.27 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	673.19 KB	-rw-rw-rw-
System.Data.OracleClient.dll	496.72 KB	-rw-rw-rw-
System.Data.Services.Client.dl...	434.23 KB	-rw-rw-rw-
System.Data.Services.Design.dl...	170.73 KB	-rw-rw-rw-
System.Data.Services.dll	657.21 KB	-rw-rw-rw-
System.Data.SqlXml.dll	717.19 KB	-rw-rw-rw-
System.Data.dll	3.31 MB	-rw-rw-rw-
System.Deployment.dll	857.89 KB	-rw-rw-rw-
System.Design.dll	4.78 MB	-rw-rw-rw-
System.Device.dll	62.68 KB	-rw-rw-rw-
System.Diagnostics.Contracts.d...	29.26 KB	-rw-rw-rw-
System.Diagnostics.Debug.dll	28.73 KB	-rw-rw-rw-
System.Diagnostics.Tools.dll	28.73 KB	-rw-rw-rw-
System.Diagnostics.Tracing.dll	29.24 KB	-rw-rw-rw-
System.DirectoryServices.Accou...	289.27 KB	-rw-rw-rw-
System.DirectoryServices.Proto...	196.8 KB	-rw-rw-rw-
System.DirectoryServices.dll	408.34 KB	-rw-rw-rw-
System.Drawing.Design.dll	110.72 KB	-rw-rw-rw-
System.Drawing.dll	583.18 KB	-rw-rw-rw-
System.Drawing.tlb	8.5 KB	-rw-rw-rw-
System.Dynamic.Runtime.dll	29.23 KB	-rw-rw-rw-
System.Dynamic.dll	127.68 KB	-rw-rw-rw-
System.EnterpriseServices.Thun...	98.25 KB	-rw-rw-rw-
System.EnterpriseServices.Wrap...	109.5 KB	-rw-rw-rw-
System.EnterpriseServices.dll	236.23 KB	-rw-rw-rw-
System.EnterpriseServices.tlb	33.5 KB	-rw-rw-rw-
System.Globalization.dll	28.71 KB	-rw-rw-rw-
System.IO.Compression.FileSyst...	32.26 KB	-rw-rw-rw-
System.IO.Compression.dll	70.22 KB	-rw-rw-rw-
System.IO.Log.dll	130.68 KB	-rw-rw-rw-
System.IO.dll	28.14 KB	-rw-rw-rw-
System.IdentityModel.Selectors...	141.27 KB	-rw-rw-rw-
System.IdentityModel.Services....	187.94 KB	-rw-rw-rw-
System.IdentityModel.dll	1.04 MB	-rw-rw-rw-
System.Linq.Expressions.dll	30.73 KB	-rw-rw-rw-
System.Linq.Parallel.dll	28.7 KB	-rw-rw-rw-
System.Linq.Queryable.dll	28.72 KB	-rw-rw-rw-
System.Linq.dll	28.66 KB	-rw-rw-rw-
System.Management.Instrumentat...	142.26 KB	-rw-rw-rw-
System.Management.dll	405.7 KB	-rw-rw-rw-
System.Messaging.dll	268.19 KB	-rw-rw-rw-
System.Net.Http.Rtc.dll	28.7 KB	-rw-rw-rw-
System.Net.Http.WebRequest.dll	49.75 KB	-rw-rw-rw-
System.Net.Http.dll	198.58 KB	-rw-rw-rw-
System.Net.NetworkInformation....	29.77 KB	-rw-rw-rw-
System.Net.Primitives.dll	29.22 KB	-rw-rw-rw-
System.Net.Requests.dll	28.7 KB	-rw-rw-rw-
System.Net.WebHeaderCollection...	28.27 KB	-rw-rw-rw-
System.Net.dll	250.65 KB	-rw-rw-rw-
System.Numerics.Vectors.dll	30.73 KB	-rw-rw-rw-
System.Numerics.dll	135.18 KB	-rw-rw-rw-
System.ObjectModel.dll	29.2 KB	-rw-rw-rw-
System.Reflection.Emit.ILGener...	28.8 KB	-rw-rw-rw-
System.Reflection.Emit.Lightwe...	28.8 KB	-rw-rw-rw-
System.Reflection.Emit.dll	28.73 KB	-rw-rw-rw-
System.Reflection.Extensions.d...	28.76 KB	-rw-rw-rw-
System.Reflection.Primitives.d...	28.76 KB	-rw-rw-rw-
System.Reflection.context.dll	105.74 KB	-rw-rw-rw-
System.Reflection.dll	29.2 KB	-rw-rw-rw-
System.Resources.ResourceManag...	28.78 KB	-rw-rw-rw-
System.Runtime.Caching.dll	106.37 KB	-rw-rw-rw-
System.Runtime.DurableInstanci...	168.28 KB	-rw-rw-rw-
System.Runtime.Extensions.dll	28.74 KB	-rw-rw-rw-
System.Runtime.Handles.dll	28.72 KB	-rw-rw-rw-
System.Runtime.InteropServices...	28.87 KB	-rw-rw-rw-
System.Runtime.InteropServices...	31.77 KB	-rw-rw-rw-
System.Runtime.Numerics.dll	28.73 KB	-rw-rw-rw-
System.Runtime.Remoting.dll	334.97 KB	-rw-rw-rw-
System.Runtime.Serialization.F...	138.36 KB	-rw-rw-rw-
System.Runtime.Serialization.J...	28.79 KB	-rw-rw-rw-
System.Runtime.Serialization.P...	28.83 KB	-rw-rw-rw-
System.Runtime.Serialization.X...	28.78 KB	-rw-rw-rw-
System.Runtime.Serialization.d...	1 MB	-rw-rw-rw-
System.Runtime.WindowsRuntime....	70.81 KB	-rw-rw-rw-
System.Runtime.WindowsRuntime....	148.27 KB	-rw-rw-rw-
System.Runtime.dll	36.67 KB	-rw-rw-rw-
System.Security.Principal.dll	28.74 KB	-rw-rw-rw-
System.Security.dll	311.24 KB	-rw-rw-rw-
System.ServiceModel.Activation...	197.74 KB	-rw-rw-rw-
System.ServiceModel.Activities...	548.24 KB	-rw-rw-rw-
System.ServiceModel.Channels.d...	148.53 KB	-rw-rw-rw-
System.ServiceModel.Discovery....	295.42 KB	-rw-rw-rw-
System.ServiceModel.Duplex.dll	28.75 KB	-rw-rw-rw-
System.ServiceModel.Http.dll	29.23 KB	-rw-rw-rw-
System.ServiceModel.Internals....	249.96 KB	-rw-rw-rw-
System.ServiceModel.NetTcp.dll	28.74 KB	-rw-rw-rw-
System.ServiceModel.Primitives...	33.27 KB	-rw-rw-rw-
System.ServiceModel.Routing.dl...	127.73 KB	-rw-rw-rw-
System.ServiceModel.Security.d...	29.26 KB	-rw-rw-rw-
System.ServiceModel.ServiceMon...	22.77 KB	-rw-rw-rw-
System.ServiceModel.WasHosting...	33.53 KB	-rw-rw-rw-
System.ServiceModel.Web.dll	320.73 KB	-rw-rw-rw-
System.ServiceModel.dll	6.03 MB	-rw-rw-rw-
System.ServiceProcess.dll	131.72 KB	-rw-rw-rw-
System.Text.Encoding.Extension...	28.27 KB	-rw-rw-rw-
System.Text.Encoding.dll	28.71 KB	-rw-rw-rw-
System.Text.RegularExpressions...	28.77 KB	-rw-rw-rw-
System.Threading.Tasks.Paralle...	28.77 KB	-rw-rw-rw-
System.Threading.Tasks.dll	29.23 KB	-rw-rw-rw-
System.Threading.Timer.dll	28.73 KB	-rw-rw-rw-
System.Threading.dll	29.19 KB	-rw-rw-rw-
System.Transactions.dll	302.08 KB	-rw-rw-rw-
System.Web.Abstractions.dll	22.38 KB	-rw-rw-rw-
System.Web.ApplicationServices...	64.49 KB	-rw-rw-rw-
System.Web.DataVisualization.D...	103.42 KB	-rw-rw-rw-
System.Web.DataVisualization.d...	1.62 MB	-rw-rw-rw-
System.Web.DynamicData.Design....	43.9 KB	-rw-rw-rw-
System.Web.DynamicData.dll	242.37 KB	-rw-rw-rw-
System.Web.Entity.Design.dll	169.23 KB	-rw-rw-rw-
System.Web.Entity.dll	161.7 KB	-rw-rw-rw-
System.Web.Extensions.Design.d...	344.4 KB	-rw-rw-rw-
System.Web.Extensions.dll	1.76 MB	-rw-rw-rw-
System.Web.Mobile.dll	811.2 KB	-rw-rw-rw-
System.Web.RegularExpressions....	103.24 KB	-rw-rw-rw-
System.Web.Routing.dll	21.85 KB	-rw-rw-rw-
System.Web.Services.dll	826.7 KB	-rw-rw-rw-
System.Web.dll	5.16 MB	-rw-rw-rw-
System.Web.tlb	7 KB	-rw-rw-rw-
System.Windows.Forms.DataVisua...	80.46 KB	-rw-rw-rw-
System.Windows.Forms.DataVisua...	1.63 MB	-rw-rw-rw-
System.Windows.Forms.dll	4.99 MB	-rw-rw-rw-
System.Windows.Forms.tlb	84.5 KB	-rw-rw-rw-
System.Windows.dll	30.68 KB	-rw-rw-rw-
System.Workflow.Activities.dll	1 MB	-rw-rw-rw-
System.Workflow.ComponentModel...	1.48 MB	-rw-rw-rw-
System.Workflow.Runtime.dll	487.77 KB	-rw-rw-rw-
System.WorkflowServices.dll	440.22 KB	-rw-rw-rw-
System.XML.dll	2.55 MB	-rw-rw-rw-
System.Xaml.Hosting.dll	41.7 KB	-rw-rw-rw-
System.Xaml.dll	622.37 KB	-rw-rw-rw-
System.Xml.Linq.dll	159.68 KB	-rw-rw-rw-
System.Xml.ReaderWriter.dll	29.23 KB	-rw-rw-rw-
System.Xml.Serialization.dll	44.73 KB	-rw-rw-rw-
System.Xml.XDocument.dll	28.71 KB	-rw-rw-rw-
System.Xml.XmlSerializer.dll	29.23 KB	-rw-rw-rw-
System.dll	3.4 MB	-rw-rw-rw-
System.tlb	70.5 KB	-rw-rw-rw-
TLBREF.DLL	110.66 KB	-rw-rw-rw-
ThirdPartyNotices.txt	19.85 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	133.17 KB	-rw-rw-rw-
Workflow.Targets	6.96 KB	-rw-rw-rw-
Workflow.VisualBasic.Targets	8.39 KB	-rw-rw-rw-
WorkflowServiceHostPerformance...	87.77 KB	-rw-rw-rw-
WorkflowServiceHostPerformance...	42.27 KB	-rw-rw-rw-
WsatConfig.exe	149.17 KB	-rwxrwxrwx
XPThemes.manifest	474 B	-rw-rw-rw-
XamlBuildTask.dll	129.18 KB	-rw-rw-rw-
XsdBuildTask.dll	66.18 KB	-rw-rw-rw-
adonetdiag.mof	7.35 KB	-rw-rw-rw-
adonetdiag.mof.uninstall	1.95 KB	-rw-rw-rw-
alink.dll	123.65 KB	-rw-rw-rw-
applaunch.exe.config	281 B	-rw-rw-rw-
aspnet_compiler.exe	54.19 KB	-rwxrwxrwx
aspnet_filter.dll	34.68 KB	-rw-rw-rw-
aspnet_isapi.dll	25.17 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	89.16 KB	-rw-rw-rw-
aspnet_regbrowsers.exe	38.55 KB	-rwxrwxrwx
aspnet_regiis.exe	34.55 KB	-rwxrwxrwx
aspnet_regsql.exe	118.55 KB	-rwxrwxrwx
aspnet_state.exe	46.17 KB	-rwxrwxrwx
aspnet_state_perf.h	318 B	-rw-rw-rw-
aspnet_state_perf.ini	41.99 KB	-rw-rw-rw-
aspnet_wp.exe	39.43 KB	-rwxrwxrwx
caspol.exe.config	368 B	-rw-rw-rw-
clr.dll	7.41 MB	-rw-rw-rw-
clrcompression.dll	127.43 KB	-rw-rw-rw-
clretwrc.dll	231.66 KB	-rw-rw-rw-
clrjit.dll	504.94 KB	-rw-rw-rw-
csc.exe	2.07 MB	-rwxrwxrwx
csc.exe.config	182 B	-rw-rw-rw-
csc.rsp	1.3 KB	-rw-rw-rw-
cvtres.exe	42.17 KB	-rwxrwxrwx
cvtres.exe.config	281 B	-rw-rw-rw-
default.win32manifest	490 B	-rw-rw-rw-
dfdll.dll	150.43 KB	-rw-rw-rw-
dfsvc.exe	23.65 KB	-rwxrwxrwx
dfsvc.exe.config	167 B	-rw-rw-rw-
diasymreader.dll	1.02 MB	-rw-rw-rw-
dv_aspnetmmc.chm	112.43 KB	-rw-rw-rw-
fusion.dll	92.66 KB	-rw-rw-rw-
ilasm.exe	289.65 KB	-rwxrwxrwx
ilasm.exe.config	223 B	-rw-rw-rw-
jsc.exe	45.64 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.27 MB	-rw-rw-rw-
mscordbi.dll	1.11 MB	-rw-rw-rw-
mscoree.tlb	31 KB	-rw-rw-rw-
mscoreei.dll	500.48 KB	-rw-rw-rw-
mscoreeis.dll	33.16 KB	-rw-rw-rw-
mscorlib.dll	5.44 MB	-rw-rw-rw-
mscorlib.tlb	507.5 KB	-rw-rw-rw-
mscorpe.dll	87.66 KB	-rw-rw-rw-
mscorpehost.dll	145.54 KB	-rw-rw-rw-
mscorrc.dll	389.66 KB	-rw-rw-rw-
mscorsecimpl.dll	104.18 KB	-rw-rw-rw-
mscorsn.dll	25.66 KB	-rw-rw-rw-
mscorsvc.dll	414.88 KB	-rw-rw-rw-
mscorsvw.exe	98.42 KB	-rwxrwxrwx
ngen.exe	131.96 KB	-rwxrwxrwx
ngen.log	182.13 KB	-rw-rw-rw-
ngen.old.log	1 MB	-rw-rw-rw-
ngentask.exe	77.95 KB	-rwxrwxrwx
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	178.42 KB	-rw-rw-rw-
regasm.exe.config	281 B	-rw-rw-rw-
regsvcs.exe.config	223 B	-rw-rw-rw-
sysglobl.dll	129.14 KB	-rw-rw-rw-
system.componentmodel.composit...	61.88 KB	-rw-rw-rw-
vbc.exe	2.56 MB	-rwxrwxrwx
vbc.exe.config	182 B	-rw-rw-rw-
vbc.rsp	1.43 KB	-rw-rw-rw-
webengine.dll	18.42 KB	-rw-rw-rw-
webengine4.dll	531.43 KB	-rw-rw-rw-

Code Editor : InstallSqlStateTemplate.sql

/*********************************************************************
  InstallSqlStateTemplate.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 InstallSqlStateTemplate.SQL'
PRINT '-------------------------------------------------'
PRINT ''
PRINT '--------------------------------------------------'
PRINT 'Note:                                             '
PRINT 'This file is included for backward compatibility  '
PRINT 'only.  You should use aspnet_regsql.exe to install'
PRINT 'and uninstall SQL session state.                  '
PRINT ''
PRINT 'Run ''aspnet_regsql.exe -?'' for details.         '
PRINT '--------------------------------------------------'
GO

/*
   InstallSqlStateTemplate.sql and UninstallSqlStateTemplate.sql are
   templates files for installing the ASP.NET session state SQL objects
   on a database other than the default 'ASPState'.

To create your own script files based on the template:
   1. Create your own script files by coping the two template files.
   2. Decide a name for your database (e.g. MyASPStateDB)
   3. In your own script files, replace all occurences of "DatabaseNamePlaceHolder"
      by your database name.
   4. Install and uninstall ASP.NET session state SQL objects using your own
      script files.
*/

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

USE master
GO

/* Create and populate the session state database */

IF DB_ID(N'DatabaseNamePlaceHolder') IS NULL BEGIN
    DECLARE @cmd nvarchar(500)
    SET @cmd = N'CREATE DATABASE [DatabaseNamePlaceHolder]'
    EXEC(@cmd)
END    
GO

/* Drop all tables, startup procedures, stored procedures and types. */

/* Drop the DeleteExpiredSessions_Job */

DECLARE @jobname nvarchar(200)
SET @jobname = N'DatabaseNamePlaceHolder' + '_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_custom'

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

USE [DatabaseNamePlaceHolder]
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 [DatabaseNamePlaceHolder]
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 [DatabaseNamePlaceHolder]

/* 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 [DatabaseNamePlaceHolder].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 [DatabaseNamePlaceHolder].dbo.ASPStateTempSessions(Expires)

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

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

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

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

IF @appId IS NULL BEGIN
        BEGIN TRAN

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

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

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'DatabaseNamePlaceHolder' + '_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'DatabaseNamePlaceHolder' + '_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'DatabaseNamePlaceHolder', 
            @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'DatabaseNamePlaceHolder' + '_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 InstallSqlStateTemplate.SQL'
PRINT '--------------------------------------------------'

${this.title}

Code Editor : InstallSqlStateTemplate.sql