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	191.17 KB	-rw-rw-rw-
AppLaunch.exe	117.16 KB	-rwxrwxrwx
Aspnet.config	437 B	-rw-rw-rw-
Aspnet_perf.dll	39.43 KB	-rw-rw-rw-
CLR-ETW.man	313.6 KB	-rw-rw-rw-
CORPerfMonExt.dll	152.68 KB	-rw-rw-rw-
CasPol.exe	104.15 KB	-rwxrwxrwx
ComSvcConfig.exe	169.68 KB	-rwxrwxrwx
Culture.dll	62.66 KB	-rw-rw-rw-
CustomMarshalers.dll	103.2 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	262.67 KB	-rw-rw-rw-
ISymWrapper.dll	71.17 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.17 KB	-rwxrwxrwx
InstallUtil.exe.config	182 B	-rw-rw-rw-
InstallUtilLib.dll	74.69 KB	-rw-rw-rw-
InstallWebEventSqlProvider.sql	6.31 KB	-rw-rw-rw-
MSBuild.exe	252.16 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....	129.76 KB	-rw-rw-rw-
Microsoft.Transactions.Bridge....	386.76 KB	-rw-rw-rw-
Microsoft.VisualBasic.Activiti...	3.76 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.36 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	112.16 KB	-rw-rw-rw-
PerfCounter.dll	254.17 KB	-rw-rw-rw-
RegAsm.exe	62.16 KB	-rwxrwxrwx
RegSvcs.exe	43.66 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	845.52 KB	-rw-rw-rw-
SbsNclPerf.dll	23.66 KB	-rw-rw-rw-
ServiceModelEvents.dll	18.7 KB	-rw-rw-rw-
ServiceModelInstallRC.dll	18.71 KB	-rw-rw-rw-
ServiceModelPerformanceCounter...	100.25 KB	-rw-rw-rw-
ServiceModelPerformanceCounter...	126.02 KB	-rw-rw-rw-
ServiceModelReg.exe	264.19 KB	-rwxrwxrwx
ServiceModelRegUI.dll	18.7 KB	-rw-rw-rw-
ServiceMonikerSupport.dll	24.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	500.23 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.37 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...	105.25 KB	-rw-rw-rw-
System.EnterpriseServices.Wrap...	124 KB	-rw-rw-rw-
System.EnterpriseServices.dll	235.73 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	303.76 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.15 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	131.16 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	183.68 KB	-rw-rw-rw-
Workflow.Targets	6.96 KB	-rw-rw-rw-
Workflow.VisualBasic.Targets	8.39 KB	-rw-rw-rw-
WorkflowServiceHostPerformance...	99.27 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	153.65 KB	-rw-rw-rw-
applaunch.exe.config	281 B	-rw-rw-rw-
aspnet_compiler.exe	53.69 KB	-rwxrwxrwx
aspnet_filter.dll	37.68 KB	-rw-rw-rw-
aspnet_isapi.dll	26.18 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	37.95 KB	-rwxrwxrwx
aspnet_regiis.exe	38.05 KB	-rwxrwxrwx
aspnet_regsql.exe	118.05 KB	-rwxrwxrwx
aspnet_state.exe	51.68 KB	-rwxrwxrwx
aspnet_state_perf.h	318 B	-rw-rw-rw-
aspnet_state_perf.ini	41.99 KB	-rw-rw-rw-
aspnet_wp.exe	44.05 KB	-rwxrwxrwx
caspol.exe.config	368 B	-rw-rw-rw-
clr.dll	10.2 MB	-rw-rw-rw-
clrcompression.dll	136.92 KB	-rw-rw-rw-
clretwrc.dll	231.66 KB	-rw-rw-rw-
clrjit.dll	1.16 MB	-rw-rw-rw-
compatjit.dll	1.2 MB	-rw-rw-rw-
csc.exe	2.61 MB	-rwxrwxrwx
csc.exe.config	182 B	-rw-rw-rw-
csc.rsp	1.3 KB	-rw-rw-rw-
cvtres.exe	46.17 KB	-rwxrwxrwx
cvtres.exe.config	281 B	-rw-rw-rw-
default.win32manifest	490 B	-rw-rw-rw-
dfdll.dll	181.4 KB	-rw-rw-rw-
dfsvc.exe	23.65 KB	-rwxrwxrwx
dfsvc.exe.config	167 B	-rw-rw-rw-
diasymreader.dll	1.39 MB	-rw-rw-rw-
dv_aspnetmmc.chm	112.43 KB	-rw-rw-rw-
fusion.dll	109.16 KB	-rw-rw-rw-
ilasm.exe	357.15 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.75 MB	-rw-rw-rw-
mscordbi.dll	1.54 MB	-rw-rw-rw-
mscoree.tlb	31 KB	-rw-rw-rw-
mscoreei.dll	616.48 KB	-rw-rw-rw-
mscoreeis.dll	33.16 KB	-rw-rw-rw-
mscorlib.dll	5.23 MB	-rw-rw-rw-
mscorlib.tlb	505.53 KB	-rw-rw-rw-
mscorpe.dll	98.66 KB	-rw-rw-rw-
mscorpehost.dll	179.42 KB	-rw-rw-rw-
mscorrc.dll	389.66 KB	-rw-rw-rw-
mscorsecimpl.dll	128.18 KB	-rw-rw-rw-
mscorsn.dll	27.16 KB	-rw-rw-rw-
mscorsvc.dll	525.38 KB	-rw-rw-rw-
mscorsvw.exe	118.92 KB	-rwxrwxrwx
ngen.exe	163.46 KB	-rwxrwxrwx
ngen.log	221.04 KB	-rw-rw-rw-
ngen.old.log	1 MB	-rw-rw-rw-
ngentask.exe	77.45 KB	-rwxrwxrwx
ngentasklauncher.dll	28.69 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	249.03 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	3.07 MB	-rwxrwxrwx
vbc.exe.config	182 B	-rw-rw-rw-
vbc.rsp	1.43 KB	-rw-rw-rw-
webengine.dll	19.92 KB	-rw-rw-rw-
webengine4.dll	645.92 KB	-rw-rw-rw-

Code Editor : InstallMembership.sql

/**********************************************************************/
/* InstallMembership.SQL                                              */
/*                                                                    */
/* Installs the tables, triggers and stored procedures necessary for  */
/* supporting the aspnet feature of ASP.Net                           */
/*                                                                    */
/* InstallCommon.sql must be run before running this file.            */
/*
** Copyright Microsoft, Inc. 2002
** All Rights Reserved.
*/
/**********************************************************************/

PRINT '-------------------------------------------'
PRINT 'Starting execution of InstallMembership.SQL'
PRINT '-------------------------------------------'
GO

SET QUOTED_IDENTIFIER OFF
SET ANSI_NULLS ON         -- We don't want (NULL = NULL) == TRUE
GO
SET ANSI_PADDING ON
GO
SET ANSI_NULL_DFLT_ON ON
GO

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

DECLARE @dbname nvarchar(128)

SET @dbname = N'aspnetdb'

IF (NOT EXISTS (SELECT name
                FROM master.dbo.sysdatabases
                WHERE ('[' + name + ']' = @dbname OR name = @dbname)))
BEGIN
  RAISERROR('The database ''%s'' cannot be found. Please run InstallCommon.sql first.', 18, 1, @dbname)
END
GO

USE [aspnetdb]
GO

IF (NOT EXISTS (SELECT name
                FROM sysobjects
                WHERE (name = N'aspnet_Applications')
                  AND (type = 'U')))
BEGIN
  RAISERROR('The table ''aspnet_Applications'' cannot be found. Please use aspnet_regsql.exe for installing ASP.NET application services.', 18, 1)
END

IF (NOT EXISTS (SELECT name
                FROM sysobjects
                WHERE (name = N'aspnet_Users')
                  AND (type = 'U')))
BEGIN
  RAISERROR('The table ''aspnet_Users'' cannot be found. Please use aspnet_regsql.exe for installing ASP.NET application services.', 18, 1)
END

IF (NOT EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_Applications_CreateApplication')
               AND (type = 'P')))
BEGIN
  RAISERROR('The stored procedure ''aspnet_Applications_CreateApplication'' cannot be found. Please use aspnet_regsql.exe for installing ASP.NET application services.', 18, 1)
END

IF (NOT EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_Users_CreateUser')
               AND (type = 'P')))
BEGIN
  RAISERROR('The stored procedure ''aspnet_Users_CreateUser'' cannot be found. Please use aspnet_regsql.exe for installing ASP.NET application services.', 18, 1)
END

IF (NOT EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_Users_DeleteUser')
               AND (type = 'P')))
BEGIN
  RAISERROR('The stored procedure ''aspnet_Users_DeleteUser'' cannot be found. Please use aspnet_regsql.exe for installing ASP.NET application services.', 18, 1)
END

/*************************************************************/
/*************************************************************/
IF (NOT EXISTS (SELECT name
                FROM sysobjects
                WHERE (name = N'aspnet_Membership')
                  AND (type = 'U')))
BEGIN
  PRINT 'Creating the aspnet_Membership table...'
  CREATE TABLE dbo.aspnet_Membership (
        ApplicationId                           uniqueidentifier    NOT NULL FOREIGN KEY REFERENCES dbo.aspnet_Applications(ApplicationId),
        UserId                                  uniqueidentifier    NOT NULL PRIMARY KEY NONCLUSTERED FOREIGN KEY REFERENCES dbo.aspnet_Users(UserId),
        Password                                nvarchar(128)       NOT NULL,
        PasswordFormat                          int                 NOT NULL DEFAULT 0,
        PasswordSalt                            nvarchar(128)       NOT NULL,
        MobilePIN                               nvarchar(16),
        Email                                   nvarchar(256),
        LoweredEmail                            nvarchar(256),
        PasswordQuestion                        nvarchar(256),
        PasswordAnswer                          nvarchar(128),
        IsApproved                              bit                 NOT NULL,
        IsLockedOut                             bit                 NOT NULL,
        CreateDate                              datetime            NOT NULL,
        LastLoginDate                           datetime            NOT NULL,
        LastPasswordChangedDate                 datetime            NOT NULL,
        LastLockoutDate                         datetime            NOT NULL,
        FailedPasswordAttemptCount              int                 NOT NULL,
        FailedPasswordAttemptWindowStart        datetime            NOT NULL,
        FailedPasswordAnswerAttemptCount        int                 NOT NULL,
        FailedPasswordAnswerAttemptWindowStart  datetime            NOT NULL,
        Comment                                 ntext )
  CREATE CLUSTERED INDEX aspnet_Membership_index ON aspnet_Membership(ApplicationId, LoweredEmail)
END
GO

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

DECLARE @ver int
DECLARE @version nchar(100)
DECLARE @dot int
DECLARE @hyphen int
DECLARE @SqlToExec nchar(400)

SELECT @ver = 8
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

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

IF (@ver >= 8)
    EXEC sp_tableoption N'aspnet_Membership', 'text in row', 3000

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

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_Membership_CreateUser')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_Membership_CreateUser
GO
CREATE PROCEDURE dbo.aspnet_Membership_CreateUser
    @ApplicationName                        nvarchar(256),
    @UserName                               nvarchar(256),
    @Password                               nvarchar(128),
    @PasswordSalt                           nvarchar(128),
    @Email                                  nvarchar(256),
    @PasswordQuestion                       nvarchar(256),
    @PasswordAnswer                         nvarchar(128),
    @IsApproved                             bit,
    @CurrentTimeUtc                         datetime,
    @CreateDate                             datetime = NULL,
    @UniqueEmail                            int      = 0,
    @PasswordFormat                         int      = 0,
    @UserId                                 uniqueidentifier OUTPUT
AS
BEGIN
    DECLARE @ApplicationId uniqueidentifier
    SELECT  @ApplicationId = NULL

DECLARE @NewUserId uniqueidentifier
    SELECT @NewUserId = NULL

DECLARE @IsLockedOut bit
    SET @IsLockedOut = 0

DECLARE @LastLockoutDate  datetime
    SET @LastLockoutDate = CONVERT( datetime, '17540101', 112 )

DECLARE @FailedPasswordAttemptCount int
    SET @FailedPasswordAttemptCount = 0

DECLARE @FailedPasswordAttemptWindowStart  datetime
    SET @FailedPasswordAttemptWindowStart = CONVERT( datetime, '17540101', 112 )

DECLARE @FailedPasswordAnswerAttemptCount int
    SET @FailedPasswordAnswerAttemptCount = 0

DECLARE @FailedPasswordAnswerAttemptWindowStart  datetime
    SET @FailedPasswordAnswerAttemptWindowStart = CONVERT( datetime, '17540101', 112 )

DECLARE @NewUserCreated bit
    DECLARE @ReturnValue   int
    SET @ReturnValue = 0

DECLARE @ErrorCode     int
    SET @ErrorCode = 0

DECLARE @TranStarted   bit
    SET @TranStarted = 0

IF( @@TRANCOUNT = 0 )
    BEGIN
	    BEGIN TRANSACTION
	    SET @TranStarted = 1
    END
    ELSE
    	SET @TranStarted = 0

EXEC dbo.aspnet_Applications_CreateApplication @ApplicationName, @ApplicationId OUTPUT

IF( @@ERROR <> 0 )
    BEGIN
        SET @ErrorCode = -1
        GOTO Cleanup
    END

SET @CreateDate = @CurrentTimeUtc

SELECT  @NewUserId = UserId FROM dbo.aspnet_Users WHERE LOWER(@UserName) = LoweredUserName AND @ApplicationId = ApplicationId
    IF ( @NewUserId IS NULL )
    BEGIN
        SET @NewUserId = @UserId
        EXEC @ReturnValue = dbo.aspnet_Users_CreateUser @ApplicationId, @UserName, 0, @CreateDate, @NewUserId OUTPUT
        SET @NewUserCreated = 1
    END
    ELSE
    BEGIN
        SET @NewUserCreated = 0
        IF( @NewUserId <> @UserId AND @UserId IS NOT NULL )
        BEGIN
            SET @ErrorCode = 6
            GOTO Cleanup
        END
    END

IF( @@ERROR <> 0 )
    BEGIN
        SET @ErrorCode = -1
        GOTO Cleanup
    END

IF( @ReturnValue = -1 )
    BEGIN
        SET @ErrorCode = 10
        GOTO Cleanup
    END

IF ( EXISTS ( SELECT UserId
                  FROM   dbo.aspnet_Membership
                  WHERE  @NewUserId = UserId ) )
    BEGIN
        SET @ErrorCode = 6
        GOTO Cleanup
    END

SET @UserId = @NewUserId

IF (@UniqueEmail = 1)
    BEGIN
        IF (EXISTS (SELECT *
                    FROM  dbo.aspnet_Membership m WITH ( UPDLOCK, HOLDLOCK )
                    WHERE ApplicationId = @ApplicationId AND LoweredEmail = LOWER(@Email)))
        BEGIN
            SET @ErrorCode = 7
            GOTO Cleanup
        END
    END

IF (@NewUserCreated = 0)
    BEGIN
        UPDATE dbo.aspnet_Users
        SET    LastActivityDate = @CreateDate
        WHERE  @UserId = UserId
        IF( @@ERROR <> 0 )
        BEGIN
            SET @ErrorCode = -1
            GOTO Cleanup
        END
    END

INSERT INTO dbo.aspnet_Membership
                ( ApplicationId,
                  UserId,
                  Password,
                  PasswordSalt,
                  Email,
                  LoweredEmail,
                  PasswordQuestion,
                  PasswordAnswer,
                  PasswordFormat,
                  IsApproved,
                  IsLockedOut,
                  CreateDate,
                  LastLoginDate,
                  LastPasswordChangedDate,
                  LastLockoutDate,
                  FailedPasswordAttemptCount,
                  FailedPasswordAttemptWindowStart,
                  FailedPasswordAnswerAttemptCount,
                  FailedPasswordAnswerAttemptWindowStart )
         VALUES ( @ApplicationId,
                  @UserId,
                  @Password,
                  @PasswordSalt,
                  @Email,
                  LOWER(@Email),
                  @PasswordQuestion,
                  @PasswordAnswer,
                  @PasswordFormat,
                  @IsApproved,
                  @IsLockedOut,
                  @CreateDate,
                  @CreateDate,
                  @CreateDate,
                  @LastLockoutDate,
                  @FailedPasswordAttemptCount,
                  @FailedPasswordAttemptWindowStart,
                  @FailedPasswordAnswerAttemptCount,
                  @FailedPasswordAnswerAttemptWindowStart )

IF( @@ERROR <> 0 )
    BEGIN
        SET @ErrorCode = -1
        GOTO Cleanup
    END

IF( @TranStarted = 1 )
    BEGIN
	    SET @TranStarted = 0
	    COMMIT TRANSACTION
    END

RETURN 0

Cleanup:

IF( @TranStarted = 1 )
    BEGIN
        SET @TranStarted = 0
    	ROLLBACK TRANSACTION
    END

RETURN @ErrorCode

END
GO

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

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_Membership_GetUserByName')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_Membership_GetUserByName
GO
CREATE PROCEDURE dbo.aspnet_Membership_GetUserByName
    @ApplicationName      nvarchar(256),
    @UserName             nvarchar(256),
    @CurrentTimeUtc       datetime,
    @UpdateLastActivity   bit = 0
AS
BEGIN
    DECLARE @UserId uniqueidentifier

IF (@UpdateLastActivity = 1)
    BEGIN
        -- select user ID from aspnet_users table
        SELECT TOP 1 @UserId = u.UserId
        FROM    dbo.aspnet_Applications a, dbo.aspnet_Users u, dbo.aspnet_Membership m
        WHERE    LOWER(@ApplicationName) = a.LoweredApplicationName AND
                u.ApplicationId = a.ApplicationId    AND
                LOWER(@UserName) = u.LoweredUserName AND u.UserId = m.UserId

IF (@@ROWCOUNT = 0) -- Username not found
            RETURN -1

UPDATE   dbo.aspnet_Users
        SET      LastActivityDate = @CurrentTimeUtc
        WHERE    @UserId = UserId

SELECT m.Email, m.PasswordQuestion, m.Comment, m.IsApproved,
                m.CreateDate, m.LastLoginDate, u.LastActivityDate, m.LastPasswordChangedDate,
                u.UserId, m.IsLockedOut, m.LastLockoutDate
        FROM    dbo.aspnet_Applications a, dbo.aspnet_Users u, dbo.aspnet_Membership m
        WHERE  @UserId = u.UserId AND u.UserId = m.UserId 
    END
    ELSE
    BEGIN
        SELECT TOP 1 m.Email, m.PasswordQuestion, m.Comment, m.IsApproved,
                m.CreateDate, m.LastLoginDate, u.LastActivityDate, m.LastPasswordChangedDate,
                u.UserId, m.IsLockedOut,m.LastLockoutDate
        FROM    dbo.aspnet_Applications a, dbo.aspnet_Users u, dbo.aspnet_Membership m
        WHERE    LOWER(@ApplicationName) = a.LoweredApplicationName AND
                u.ApplicationId = a.ApplicationId    AND
                LOWER(@UserName) = u.LoweredUserName AND u.UserId = m.UserId

IF (@@ROWCOUNT = 0) -- Username not found
            RETURN -1
    END

RETURN 0
END
GO

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

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_Membership_GetUserByUserId')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_Membership_GetUserByUserId
GO
CREATE PROCEDURE dbo.aspnet_Membership_GetUserByUserId
    @UserId               uniqueidentifier,
    @CurrentTimeUtc       datetime,
    @UpdateLastActivity   bit = 0
AS
BEGIN
    IF ( @UpdateLastActivity = 1 )
    BEGIN
        UPDATE   dbo.aspnet_Users
        SET      LastActivityDate = @CurrentTimeUtc
        FROM     dbo.aspnet_Users
        WHERE    @UserId = UserId

IF ( @@ROWCOUNT = 0 ) -- User ID not found
            RETURN -1
    END

SELECT  m.Email, m.PasswordQuestion, m.Comment, m.IsApproved,
            m.CreateDate, m.LastLoginDate, u.LastActivityDate,
            m.LastPasswordChangedDate, u.UserName, m.IsLockedOut,
            m.LastLockoutDate
    FROM    dbo.aspnet_Users u, dbo.aspnet_Membership m
    WHERE   @UserId = u.UserId AND u.UserId = m.UserId

IF ( @@ROWCOUNT = 0 ) -- User ID not found
       RETURN -1

RETURN 0
END
GO

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

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_Membership_GetUserByEmail')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_Membership_GetUserByEmail
GO
CREATE PROCEDURE dbo.aspnet_Membership_GetUserByEmail
    @ApplicationName  nvarchar(256),
    @Email            nvarchar(256)
AS
BEGIN
    IF( @Email IS NULL )
        SELECT  u.UserName
        FROM    dbo.aspnet_Applications a, dbo.aspnet_Users u, dbo.aspnet_Membership m
        WHERE   LOWER(@ApplicationName) = a.LoweredApplicationName AND
                u.ApplicationId = a.ApplicationId    AND
                u.UserId = m.UserId AND
                m.ApplicationId = a.ApplicationId AND
                m.LoweredEmail IS NULL
    ELSE
        SELECT  u.UserName
        FROM    dbo.aspnet_Applications a, dbo.aspnet_Users u, dbo.aspnet_Membership m
        WHERE   LOWER(@ApplicationName) = a.LoweredApplicationName AND
                u.ApplicationId = a.ApplicationId    AND
                u.UserId = m.UserId AND
                m.ApplicationId = a.ApplicationId AND
                LOWER(@Email) = m.LoweredEmail

IF (@@rowcount = 0)
        RETURN(1)
    RETURN(0)
END
GO

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

IF ( EXISTS( SELECT name
             FROM sysobjects
             WHERE ( name = N'aspnet_Membership_GetPasswordWithFormat' )
                   AND ( type = 'P' ) ) )
DROP PROCEDURE dbo.aspnet_Membership_GetPasswordWithFormat
GO
CREATE PROCEDURE dbo.aspnet_Membership_GetPasswordWithFormat
    @ApplicationName                nvarchar(256),
    @UserName                       nvarchar(256),
    @UpdateLastLoginActivityDate    bit,
    @CurrentTimeUtc                 datetime
AS
BEGIN
    DECLARE @IsLockedOut                        bit
    DECLARE @UserId                             uniqueidentifier
    DECLARE @Password                           nvarchar(128)
    DECLARE @PasswordSalt                       nvarchar(128)
    DECLARE @PasswordFormat                     int
    DECLARE @FailedPasswordAttemptCount         int
    DECLARE @FailedPasswordAnswerAttemptCount   int
    DECLARE @IsApproved                         bit
    DECLARE @LastActivityDate                   datetime
    DECLARE @LastLoginDate                      datetime

SELECT  @UserId          = NULL

SELECT  @UserId = u.UserId, @IsLockedOut = m.IsLockedOut, @Password=Password, @PasswordFormat=PasswordFormat,
            @PasswordSalt=PasswordSalt, @FailedPasswordAttemptCount=FailedPasswordAttemptCount,
		    @FailedPasswordAnswerAttemptCount=FailedPasswordAnswerAttemptCount, @IsApproved=IsApproved,
            @LastActivityDate = LastActivityDate, @LastLoginDate = LastLoginDate
    FROM    dbo.aspnet_Applications a, dbo.aspnet_Users u, dbo.aspnet_Membership m
    WHERE   LOWER(@ApplicationName) = a.LoweredApplicationName AND
            u.ApplicationId = a.ApplicationId    AND
            u.UserId = m.UserId AND
            LOWER(@UserName) = u.LoweredUserName

IF (@UserId IS NULL)
        RETURN 1

IF (@IsLockedOut = 1)
        RETURN 99

SELECT   @Password, @PasswordFormat, @PasswordSalt, @FailedPasswordAttemptCount,
             @FailedPasswordAnswerAttemptCount, @IsApproved, @LastLoginDate, @LastActivityDate

IF (@UpdateLastLoginActivityDate = 1 AND @IsApproved = 1)
    BEGIN
        UPDATE  dbo.aspnet_Membership
        SET     LastLoginDate = @CurrentTimeUtc
        WHERE   UserId = @UserId

UPDATE  dbo.aspnet_Users
        SET     LastActivityDate = @CurrentTimeUtc
        WHERE   @UserId = UserId
    END

RETURN 0
END
GO
/*************************************************************/
/*************************************************************/

IF ( EXISTS( SELECT name
             FROM sysobjects
             WHERE ( name = N'aspnet_Membership_UpdateUserInfo' )
                   AND ( type = 'P' ) ) )
DROP PROCEDURE dbo.aspnet_Membership_UpdateUserInfo
GO
CREATE PROCEDURE dbo.aspnet_Membership_UpdateUserInfo
    @ApplicationName                nvarchar(256),
    @UserName                       nvarchar(256),
    @IsPasswordCorrect              bit,
    @UpdateLastLoginActivityDate    bit,
    @MaxInvalidPasswordAttempts     int,
    @PasswordAttemptWindow          int,
    @CurrentTimeUtc                 datetime,
    @LastLoginDate                  datetime,
    @LastActivityDate               datetime
AS
BEGIN
    DECLARE @UserId                                 uniqueidentifier
    DECLARE @IsApproved                             bit
    DECLARE @IsLockedOut                            bit
    DECLARE @LastLockoutDate                        datetime
    DECLARE @FailedPasswordAttemptCount             int
    DECLARE @FailedPasswordAttemptWindowStart       datetime
    DECLARE @FailedPasswordAnswerAttemptCount       int
    DECLARE @FailedPasswordAnswerAttemptWindowStart datetime

DECLARE @ErrorCode     int
    SET @ErrorCode = 0

DECLARE @TranStarted   bit
    SET @TranStarted = 0

IF( @@TRANCOUNT = 0 )
    BEGIN
	    BEGIN TRANSACTION
	    SET @TranStarted = 1
    END
    ELSE
    	SET @TranStarted = 0

SELECT  @UserId = u.UserId,
            @IsApproved = m.IsApproved,
            @IsLockedOut = m.IsLockedOut,
            @LastLockoutDate = m.LastLockoutDate,
            @FailedPasswordAttemptCount = m.FailedPasswordAttemptCount,
            @FailedPasswordAttemptWindowStart = m.FailedPasswordAttemptWindowStart,
            @FailedPasswordAnswerAttemptCount = m.FailedPasswordAnswerAttemptCount,
            @FailedPasswordAnswerAttemptWindowStart = m.FailedPasswordAnswerAttemptWindowStart
    FROM    dbo.aspnet_Applications a, dbo.aspnet_Users u WITH ( UPDLOCK, ROWLOCK ), dbo.aspnet_Membership m WITH ( UPDLOCK, ROWLOCK )
    WHERE   LOWER(@ApplicationName) = a.LoweredApplicationName AND
            u.ApplicationId = a.ApplicationId    AND
            u.UserId = m.UserId AND
            LOWER(@UserName) = u.LoweredUserName

IF ( @@rowcount = 0 )
    BEGIN
        SET @ErrorCode = 1
        GOTO Cleanup
    END

IF( @IsLockedOut = 1 )
    BEGIN
        GOTO Cleanup
    END

IF( @IsPasswordCorrect = 0 )
    BEGIN
        IF( @CurrentTimeUtc > DATEADD( minute, @PasswordAttemptWindow, @FailedPasswordAttemptWindowStart ) )
        BEGIN
            SET @FailedPasswordAttemptWindowStart = @CurrentTimeUtc
            SET @FailedPasswordAttemptCount = 1
        END
        ELSE
        BEGIN
            SET @FailedPasswordAttemptWindowStart = @CurrentTimeUtc
            SET @FailedPasswordAttemptCount = @FailedPasswordAttemptCount + 1
        END

BEGIN
            IF( @FailedPasswordAttemptCount >= @MaxInvalidPasswordAttempts )
            BEGIN
                SET @IsLockedOut = 1
                SET @LastLockoutDate = @CurrentTimeUtc
            END
        END
    END
    ELSE
    BEGIN
        IF( @FailedPasswordAttemptCount > 0 OR @FailedPasswordAnswerAttemptCount > 0 )
        BEGIN
            SET @FailedPasswordAttemptCount = 0
            SET @FailedPasswordAttemptWindowStart = CONVERT( datetime, '17540101', 112 )
            SET @FailedPasswordAnswerAttemptCount = 0
            SET @FailedPasswordAnswerAttemptWindowStart = CONVERT( datetime, '17540101', 112 )
            SET @LastLockoutDate = CONVERT( datetime, '17540101', 112 )
        END
    END

IF( @UpdateLastLoginActivityDate = 1 )
    BEGIN
        UPDATE  dbo.aspnet_Users WITH (ROWLOCK)
        SET     LastActivityDate = @LastActivityDate
        WHERE   @UserId = UserId

IF( @@ERROR <> 0 )
        BEGIN
            SET @ErrorCode = -1
            GOTO Cleanup
        END

UPDATE  dbo.aspnet_Membership
        SET     LastLoginDate = @LastLoginDate
        WHERE   UserId = @UserId

IF( @@ERROR <> 0 )
        BEGIN
            SET @ErrorCode = -1
            GOTO Cleanup
        END
    END

UPDATE dbo.aspnet_Membership WITH (ROWLOCK)
    SET IsLockedOut = @IsLockedOut, LastLockoutDate = @LastLockoutDate,
        FailedPasswordAttemptCount = @FailedPasswordAttemptCount,
        FailedPasswordAttemptWindowStart = @FailedPasswordAttemptWindowStart,
        FailedPasswordAnswerAttemptCount = @FailedPasswordAnswerAttemptCount,
        FailedPasswordAnswerAttemptWindowStart = @FailedPasswordAnswerAttemptWindowStart
    WHERE @UserId = UserId

IF( @@ERROR <> 0 )
    BEGIN
        SET @ErrorCode = -1
        GOTO Cleanup
    END

IF( @TranStarted = 1 )
    BEGIN
	SET @TranStarted = 0
	COMMIT TRANSACTION
    END

RETURN @ErrorCode

Cleanup:

IF( @TranStarted = 1 )
    BEGIN
        SET @TranStarted = 0
    	ROLLBACK TRANSACTION
    END

RETURN @ErrorCode

END
GO

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

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_Membership_GetPassword')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_Membership_GetPassword
GO
CREATE PROCEDURE dbo.aspnet_Membership_GetPassword
    @ApplicationName                nvarchar(256),
    @UserName                       nvarchar(256),
    @MaxInvalidPasswordAttempts     int,
    @PasswordAttemptWindow          int,
    @CurrentTimeUtc                 datetime,
    @PasswordAnswer                 nvarchar(128) = NULL
AS
BEGIN
    DECLARE @UserId                                 uniqueidentifier
    DECLARE @PasswordFormat                         int
    DECLARE @Password                               nvarchar(128)
    DECLARE @passAns                                nvarchar(128)
    DECLARE @IsLockedOut                            bit
    DECLARE @LastLockoutDate                        datetime
    DECLARE @FailedPasswordAttemptCount             int
    DECLARE @FailedPasswordAttemptWindowStart       datetime
    DECLARE @FailedPasswordAnswerAttemptCount       int
    DECLARE @FailedPasswordAnswerAttemptWindowStart datetime

DECLARE @ErrorCode     int
    SET @ErrorCode = 0

DECLARE @TranStarted   bit
    SET @TranStarted = 0

IF( @@TRANCOUNT = 0 )
    BEGIN
	    BEGIN TRANSACTION
	    SET @TranStarted = 1
    END
    ELSE
    	SET @TranStarted = 0

SELECT  @UserId = u.UserId,
            @Password = m.Password,
            @passAns = m.PasswordAnswer,
            @PasswordFormat = m.PasswordFormat,
            @IsLockedOut = m.IsLockedOut,
            @LastLockoutDate = m.LastLockoutDate,
            @FailedPasswordAttemptCount = m.FailedPasswordAttemptCount,
            @FailedPasswordAttemptWindowStart = m.FailedPasswordAttemptWindowStart,
            @FailedPasswordAnswerAttemptCount = m.FailedPasswordAnswerAttemptCount,
            @FailedPasswordAnswerAttemptWindowStart = m.FailedPasswordAnswerAttemptWindowStart
    FROM    dbo.aspnet_Applications a, dbo.aspnet_Users u, dbo.aspnet_Membership m WITH ( UPDLOCK )
    WHERE   LOWER(@ApplicationName) = a.LoweredApplicationName AND
            u.ApplicationId = a.ApplicationId    AND
            u.UserId = m.UserId AND
            LOWER(@UserName) = u.LoweredUserName

IF ( @@rowcount = 0 )
    BEGIN
        SET @ErrorCode = 1
        GOTO Cleanup
    END

IF( @IsLockedOut = 1 )
    BEGIN
        SET @ErrorCode = 99
        GOTO Cleanup
    END

IF ( NOT( @PasswordAnswer IS NULL ) )
    BEGIN
        IF( ( @passAns IS NULL ) OR ( LOWER( @passAns ) <> LOWER( @PasswordAnswer ) ) )
        BEGIN
            IF( @CurrentTimeUtc > DATEADD( minute, @PasswordAttemptWindow, @FailedPasswordAnswerAttemptWindowStart ) )
            BEGIN
                SET @FailedPasswordAnswerAttemptWindowStart = @CurrentTimeUtc
                SET @FailedPasswordAnswerAttemptCount = 1
            END
            ELSE
            BEGIN
                SET @FailedPasswordAnswerAttemptCount = @FailedPasswordAnswerAttemptCount + 1
                SET @FailedPasswordAnswerAttemptWindowStart = @CurrentTimeUtc
            END

BEGIN
                IF( @FailedPasswordAnswerAttemptCount >= @MaxInvalidPasswordAttempts )
                BEGIN
                    SET @IsLockedOut = 1
                    SET @LastLockoutDate = @CurrentTimeUtc
                END
            END

SET @ErrorCode = 3
        END
        ELSE
        BEGIN
            IF( @FailedPasswordAnswerAttemptCount > 0 )
            BEGIN
                SET @FailedPasswordAnswerAttemptCount = 0
                SET @FailedPasswordAnswerAttemptWindowStart = CONVERT( datetime, '17540101', 112 )
            END
        END

UPDATE dbo.aspnet_Membership
        SET IsLockedOut = @IsLockedOut, LastLockoutDate = @LastLockoutDate,
            FailedPasswordAttemptCount = @FailedPasswordAttemptCount,
            FailedPasswordAttemptWindowStart = @FailedPasswordAttemptWindowStart,
            FailedPasswordAnswerAttemptCount = @FailedPasswordAnswerAttemptCount,
            FailedPasswordAnswerAttemptWindowStart = @FailedPasswordAnswerAttemptWindowStart
        WHERE @UserId = UserId

IF( @@ERROR <> 0 )
        BEGIN
            SET @ErrorCode = -1
            GOTO Cleanup
        END
    END

IF( @TranStarted = 1 )
    BEGIN
	SET @TranStarted = 0
	COMMIT TRANSACTION
    END

IF( @ErrorCode = 0 )
        SELECT @Password, @PasswordFormat

RETURN @ErrorCode

Cleanup:

IF( @TranStarted = 1 )
    BEGIN
        SET @TranStarted = 0
    	ROLLBACK TRANSACTION
    END

RETURN @ErrorCode

END
GO

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

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_Membership_SetPassword')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_Membership_SetPassword
GO
CREATE PROCEDURE dbo.aspnet_Membership_SetPassword
    @ApplicationName  nvarchar(256),
    @UserName         nvarchar(256),
    @NewPassword      nvarchar(128),
    @PasswordSalt     nvarchar(128),
    @CurrentTimeUtc   datetime,
    @PasswordFormat   int = 0
AS
BEGIN
    DECLARE @UserId uniqueidentifier
    SELECT  @UserId = NULL
    SELECT  @UserId = u.UserId
    FROM    dbo.aspnet_Users u, dbo.aspnet_Applications a, dbo.aspnet_Membership m
    WHERE   LoweredUserName = LOWER(@UserName) AND
            u.ApplicationId = a.ApplicationId  AND
            LOWER(@ApplicationName) = a.LoweredApplicationName AND
            u.UserId = m.UserId

IF (@UserId IS NULL)
        RETURN(1)

UPDATE dbo.aspnet_Membership
    SET Password = @NewPassword, PasswordFormat = @PasswordFormat, PasswordSalt = @PasswordSalt,
        LastPasswordChangedDate = @CurrentTimeUtc
    WHERE @UserId = UserId
    RETURN(0)
END
GO

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

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_Membership_ResetPassword')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_Membership_ResetPassword
GO
CREATE PROCEDURE dbo.aspnet_Membership_ResetPassword
    @ApplicationName             nvarchar(256),
    @UserName                    nvarchar(256),
    @NewPassword                 nvarchar(128),
    @MaxInvalidPasswordAttempts  int,
    @PasswordAttemptWindow       int,
    @PasswordSalt                nvarchar(128),
    @CurrentTimeUtc              datetime,
    @PasswordFormat              int = 0,
    @PasswordAnswer              nvarchar(128) = NULL
AS
BEGIN
    DECLARE @IsLockedOut                            bit
    DECLARE @LastLockoutDate                        datetime
    DECLARE @FailedPasswordAttemptCount             int
    DECLARE @FailedPasswordAttemptWindowStart       datetime
    DECLARE @FailedPasswordAnswerAttemptCount       int
    DECLARE @FailedPasswordAnswerAttemptWindowStart datetime

DECLARE @UserId                                 uniqueidentifier
    SET     @UserId = NULL

DECLARE @ErrorCode     int
    SET @ErrorCode = 0

DECLARE @TranStarted   bit
    SET @TranStarted = 0

IF( @@TRANCOUNT = 0 )
    BEGIN
	    BEGIN TRANSACTION
	    SET @TranStarted = 1
    END
    ELSE
    	SET @TranStarted = 0

SELECT  @UserId = u.UserId
    FROM    dbo.aspnet_Users u, dbo.aspnet_Applications a, dbo.aspnet_Membership m
    WHERE   LoweredUserName = LOWER(@UserName) AND
            u.ApplicationId = a.ApplicationId  AND
            LOWER(@ApplicationName) = a.LoweredApplicationName AND
            u.UserId = m.UserId

IF ( @UserId IS NULL )
    BEGIN
        SET @ErrorCode = 1
        GOTO Cleanup
    END

SELECT @IsLockedOut = IsLockedOut,
           @LastLockoutDate = LastLockoutDate,
           @FailedPasswordAttemptCount = FailedPasswordAttemptCount,
           @FailedPasswordAttemptWindowStart = FailedPasswordAttemptWindowStart,
           @FailedPasswordAnswerAttemptCount = FailedPasswordAnswerAttemptCount,
           @FailedPasswordAnswerAttemptWindowStart = FailedPasswordAnswerAttemptWindowStart
    FROM dbo.aspnet_Membership WITH ( UPDLOCK )
    WHERE @UserId = UserId

IF( @IsLockedOut = 1 )
    BEGIN
        SET @ErrorCode = 99
        GOTO Cleanup
    END

UPDATE dbo.aspnet_Membership
    SET    Password = @NewPassword,
           LastPasswordChangedDate = @CurrentTimeUtc,
           PasswordFormat = @PasswordFormat,
           PasswordSalt = @PasswordSalt
    WHERE  @UserId = UserId AND
           ( ( @PasswordAnswer IS NULL ) OR ( LOWER( PasswordAnswer ) = LOWER( @PasswordAnswer ) ) )

IF ( @@ROWCOUNT = 0 )
        BEGIN
            IF( @CurrentTimeUtc > DATEADD( minute, @PasswordAttemptWindow, @FailedPasswordAnswerAttemptWindowStart ) )
            BEGIN
                SET @FailedPasswordAnswerAttemptWindowStart = @CurrentTimeUtc
                SET @FailedPasswordAnswerAttemptCount = 1
            END
            ELSE
            BEGIN
                SET @FailedPasswordAnswerAttemptWindowStart = @CurrentTimeUtc
                SET @FailedPasswordAnswerAttemptCount = @FailedPasswordAnswerAttemptCount + 1
            END

SET @ErrorCode = 3
        END
    ELSE
        BEGIN
            IF( @FailedPasswordAnswerAttemptCount > 0 )
            BEGIN
                SET @FailedPasswordAnswerAttemptCount = 0
                SET @FailedPasswordAnswerAttemptWindowStart = CONVERT( datetime, '17540101', 112 )
            END
        END

IF( NOT ( @PasswordAnswer IS NULL ) )
    BEGIN
        UPDATE dbo.aspnet_Membership
        SET IsLockedOut = @IsLockedOut, LastLockoutDate = @LastLockoutDate,
            FailedPasswordAttemptCount = @FailedPasswordAttemptCount,
            FailedPasswordAttemptWindowStart = @FailedPasswordAttemptWindowStart,
            FailedPasswordAnswerAttemptCount = @FailedPasswordAnswerAttemptCount,
            FailedPasswordAnswerAttemptWindowStart = @FailedPasswordAnswerAttemptWindowStart
        WHERE @UserId = UserId

IF( @@ERROR <> 0 )
        BEGIN
            SET @ErrorCode = -1
            GOTO Cleanup
        END
    END

IF( @TranStarted = 1 )
    BEGIN
	SET @TranStarted = 0
	COMMIT TRANSACTION
    END

RETURN @ErrorCode

Cleanup:

IF( @TranStarted = 1 )
    BEGIN
        SET @TranStarted = 0
    	ROLLBACK TRANSACTION
    END

RETURN @ErrorCode

END
GO

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

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_Membership_UnlockUser')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_Membership_UnlockUser
GO
CREATE PROCEDURE dbo.aspnet_Membership_UnlockUser
    @ApplicationName                         nvarchar(256),
    @UserName                                nvarchar(256)
AS
BEGIN
    DECLARE @UserId uniqueidentifier
    SELECT  @UserId = NULL
    SELECT  @UserId = u.UserId
    FROM    dbo.aspnet_Users u, dbo.aspnet_Applications a, dbo.aspnet_Membership m
    WHERE   LoweredUserName = LOWER(@UserName) AND
            u.ApplicationId = a.ApplicationId  AND
            LOWER(@ApplicationName) = a.LoweredApplicationName AND
            u.UserId = m.UserId

IF ( @UserId IS NULL )
        RETURN 1

UPDATE dbo.aspnet_Membership
    SET IsLockedOut = 0,
        FailedPasswordAttemptCount = 0,
        FailedPasswordAttemptWindowStart = CONVERT( datetime, '17540101', 112 ),
        FailedPasswordAnswerAttemptCount = 0,
        FailedPasswordAnswerAttemptWindowStart = CONVERT( datetime, '17540101', 112 ),
        LastLockoutDate = CONVERT( datetime, '17540101', 112 )
    WHERE @UserId = UserId

RETURN 0
END
GO

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

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_Membership_UpdateUser')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_Membership_UpdateUser
GO
CREATE PROCEDURE dbo.aspnet_Membership_UpdateUser
    @ApplicationName      nvarchar(256),
    @UserName             nvarchar(256),
    @Email                nvarchar(256),
    @Comment              ntext,
    @IsApproved           bit,
    @LastLoginDate        datetime,
    @LastActivityDate     datetime,
    @UniqueEmail          int,
    @CurrentTimeUtc       datetime
AS
BEGIN
    DECLARE @UserId uniqueidentifier
    DECLARE @ApplicationId uniqueidentifier
    SELECT  @UserId = NULL
    SELECT  @UserId = u.UserId, @ApplicationId = a.ApplicationId
    FROM    dbo.aspnet_Users u, dbo.aspnet_Applications a, dbo.aspnet_Membership m
    WHERE   LoweredUserName = LOWER(@UserName) AND
            u.ApplicationId = a.ApplicationId  AND
            LOWER(@ApplicationName) = a.LoweredApplicationName AND
            u.UserId = m.UserId

IF (@UserId IS NULL)
        RETURN(1)

IF (@UniqueEmail = 1)
    BEGIN
        IF (EXISTS (SELECT *
                    FROM  dbo.aspnet_Membership WITH (UPDLOCK, HOLDLOCK)
                    WHERE ApplicationId = @ApplicationId  AND @UserId <> UserId AND LoweredEmail = LOWER(@Email)))
        BEGIN
            RETURN(7)
        END
    END

DECLARE @TranStarted   bit
    SET @TranStarted = 0

IF( @@TRANCOUNT = 0 )
    BEGIN
	    BEGIN TRANSACTION
	    SET @TranStarted = 1
    END
    ELSE
	SET @TranStarted = 0

UPDATE dbo.aspnet_Users WITH (ROWLOCK)
    SET
         LastActivityDate = @LastActivityDate
    WHERE
       @UserId = UserId

IF( @@ERROR <> 0 )
        GOTO Cleanup

UPDATE dbo.aspnet_Membership WITH (ROWLOCK)
    SET
         Email            = @Email,
         LoweredEmail     = LOWER(@Email),
         Comment          = @Comment,
         IsApproved       = @IsApproved,
         LastLoginDate    = @LastLoginDate
    WHERE
       @UserId = UserId

IF( @@ERROR <> 0 )
        GOTO Cleanup

IF( @TranStarted = 1 )
    BEGIN
	SET @TranStarted = 0
	COMMIT TRANSACTION
    END

RETURN 0

Cleanup:

IF( @TranStarted = 1 )
    BEGIN
        SET @TranStarted = 0
    	ROLLBACK TRANSACTION
    END

RETURN -1
END
GO

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

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_Membership_ChangePasswordQuestionAndAnswer')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_Membership_ChangePasswordQuestionAndAnswer
GO
CREATE PROCEDURE dbo.aspnet_Membership_ChangePasswordQuestionAndAnswer
    @ApplicationName       nvarchar(256),
    @UserName              nvarchar(256),
    @NewPasswordQuestion   nvarchar(256),
    @NewPasswordAnswer     nvarchar(128)
AS
BEGIN
    DECLARE @UserId uniqueidentifier
    SELECT  @UserId = NULL
    SELECT  @UserId = u.UserId
    FROM    dbo.aspnet_Membership m, dbo.aspnet_Users u, dbo.aspnet_Applications a
    WHERE   LoweredUserName = LOWER(@UserName) AND
            u.ApplicationId = a.ApplicationId  AND
            LOWER(@ApplicationName) = a.LoweredApplicationName AND
            u.UserId = m.UserId
    IF (@UserId IS NULL)
    BEGIN
        RETURN(1)
    END

UPDATE dbo.aspnet_Membership
    SET    PasswordQuestion = @NewPasswordQuestion, PasswordAnswer = @NewPasswordAnswer
    WHERE  UserId=@UserId
    RETURN(0)
END
GO
/*************************************************************/
/*************************************************************/

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_Membership_GetAllUsers')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_Membership_GetAllUsers
GO
CREATE PROCEDURE dbo.aspnet_Membership_GetAllUsers
    @ApplicationName       nvarchar(256),
    @PageIndex             int,
    @PageSize              int
AS
BEGIN
    DECLARE @ApplicationId uniqueidentifier
    SELECT  @ApplicationId = NULL
    SELECT  @ApplicationId = ApplicationId FROM dbo.aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
    IF (@ApplicationId IS NULL)
        RETURN 0

-- Set the page bounds
    DECLARE @PageLowerBound int
    DECLARE @PageUpperBound int
    DECLARE @TotalRecords   int
    SET @PageLowerBound = @PageSize * @PageIndex
    SET @PageUpperBound = @PageSize - 1 + @PageLowerBound

-- Create a temp table TO store the select results
    CREATE TABLE #PageIndexForUsers
    (
        IndexId int IDENTITY (0, 1) NOT NULL,
        UserId uniqueidentifier
    )

-- Insert into our temp table
    INSERT INTO #PageIndexForUsers (UserId)
    SELECT u.UserId
    FROM   dbo.aspnet_Membership m, dbo.aspnet_Users u
    WHERE  u.ApplicationId = @ApplicationId AND u.UserId = m.UserId
    ORDER BY u.UserName

SELECT @TotalRecords = @@ROWCOUNT

SELECT u.UserName, m.Email, m.PasswordQuestion, m.Comment, m.IsApproved,
            m.CreateDate,
            m.LastLoginDate,
            u.LastActivityDate,
            m.LastPasswordChangedDate,
            u.UserId, m.IsLockedOut,
            m.LastLockoutDate
    FROM   dbo.aspnet_Membership m, dbo.aspnet_Users u, #PageIndexForUsers p
    WHERE  u.UserId = p.UserId AND u.UserId = m.UserId AND
           p.IndexId >= @PageLowerBound AND p.IndexId <= @PageUpperBound
    ORDER BY u.UserName
    RETURN @TotalRecords
END
GO
/*************************************************************/
/*************************************************************/

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_Membership_GetNumberOfUsersOnline')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_Membership_GetNumberOfUsersOnline
GO
CREATE PROCEDURE dbo.aspnet_Membership_GetNumberOfUsersOnline
    @ApplicationName            nvarchar(256),
    @MinutesSinceLastInActive   int,
    @CurrentTimeUtc             datetime
AS
BEGIN
    DECLARE @DateActive datetime
    SELECT  @DateActive = DATEADD(minute,  -(@MinutesSinceLastInActive), @CurrentTimeUtc)

DECLARE @NumOnline int
    SELECT  @NumOnline = COUNT(*)
    FROM    dbo.aspnet_Users u(NOLOCK),
            dbo.aspnet_Applications a(NOLOCK),
            dbo.aspnet_Membership m(NOLOCK)
    WHERE   u.ApplicationId = a.ApplicationId                  AND
            LastActivityDate > @DateActive                     AND
            a.LoweredApplicationName = LOWER(@ApplicationName) AND
            u.UserId = m.UserId
    RETURN(@NumOnline)
END
GO

/*************************************************************/
/*************************************************************/
IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_Membership_FindUsersByName')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_Membership_FindUsersByName
GO
CREATE PROCEDURE dbo.aspnet_Membership_FindUsersByName
    @ApplicationName       nvarchar(256),
    @UserNameToMatch       nvarchar(256),
    @PageIndex             int,
    @PageSize              int
AS
BEGIN
    DECLARE @ApplicationId uniqueidentifier
    SELECT  @ApplicationId = NULL
    SELECT  @ApplicationId = ApplicationId FROM dbo.aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
    IF (@ApplicationId IS NULL)
        RETURN 0

-- Create a temp table TO store the select results
    CREATE TABLE #PageIndexForUsers
    (
        IndexId int IDENTITY (0, 1) NOT NULL,
        UserId uniqueidentifier
    )

-- Insert into our temp table
    INSERT INTO #PageIndexForUsers (UserId)
        SELECT u.UserId
        FROM   dbo.aspnet_Users u, dbo.aspnet_Membership m
        WHERE  u.ApplicationId = @ApplicationId AND m.UserId = u.UserId AND u.LoweredUserName LIKE LOWER(@UserNameToMatch)
        ORDER BY u.UserName

SELECT  u.UserName, m.Email, m.PasswordQuestion, m.Comment, m.IsApproved,
            m.CreateDate,
            m.LastLoginDate,
            u.LastActivityDate,
            m.LastPasswordChangedDate,
            u.UserId, m.IsLockedOut,
            m.LastLockoutDate
    FROM   dbo.aspnet_Membership m, dbo.aspnet_Users u, #PageIndexForUsers p
    WHERE  u.UserId = p.UserId AND u.UserId = m.UserId AND
           p.IndexId >= @PageLowerBound AND p.IndexId <= @PageUpperBound
    ORDER BY u.UserName

SELECT  @TotalRecords = COUNT(*)
    FROM    #PageIndexForUsers
    RETURN @TotalRecords
END
GO
/*************************************************************/
/*************************************************************/
IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_Membership_FindUsersByEmail')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_Membership_FindUsersByEmail
GO
CREATE PROCEDURE dbo.aspnet_Membership_FindUsersByEmail
    @ApplicationName       nvarchar(256),
    @EmailToMatch          nvarchar(256),
    @PageIndex             int,
    @PageSize              int
AS
BEGIN
    DECLARE @ApplicationId uniqueidentifier
    SELECT  @ApplicationId = NULL
    SELECT  @ApplicationId = ApplicationId FROM dbo.aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
    IF (@ApplicationId IS NULL)
        RETURN 0

-- Create a temp table TO store the select results
    CREATE TABLE #PageIndexForUsers
    (
        IndexId int IDENTITY (0, 1) NOT NULL,
        UserId uniqueidentifier
    )

-- Insert into our temp table
    IF( @EmailToMatch IS NULL )
        INSERT INTO #PageIndexForUsers (UserId)
            SELECT u.UserId
            FROM   dbo.aspnet_Users u, dbo.aspnet_Membership m
            WHERE  u.ApplicationId = @ApplicationId AND m.UserId = u.UserId AND m.Email IS NULL
            ORDER BY m.LoweredEmail
    ELSE
        INSERT INTO #PageIndexForUsers (UserId)
            SELECT u.UserId
            FROM   dbo.aspnet_Users u, dbo.aspnet_Membership m
            WHERE  u.ApplicationId = @ApplicationId AND m.UserId = u.UserId AND m.LoweredEmail LIKE LOWER(@EmailToMatch)
            ORDER BY m.LoweredEmail

SELECT  u.UserName, m.Email, m.PasswordQuestion, m.Comment, m.IsApproved,
            m.CreateDate,
            m.LastLoginDate,
            u.LastActivityDate,
            m.LastPasswordChangedDate,
            u.UserId, m.IsLockedOut,
            m.LastLockoutDate
    FROM   dbo.aspnet_Membership m, dbo.aspnet_Users u, #PageIndexForUsers p
    WHERE  u.UserId = p.UserId AND u.UserId = m.UserId AND
           p.IndexId >= @PageLowerBound AND p.IndexId <= @PageUpperBound
    ORDER BY m.LoweredEmail

SELECT  @TotalRecords = COUNT(*)
    FROM    #PageIndexForUsers
    RETURN @TotalRecords
END
GO

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

IF (NOT EXISTS (SELECT name
                FROM sysobjects
                WHERE (name = N'vw_aspnet_MembershipUsers')
                  AND (type = 'V')))
BEGIN
  PRINT 'Creating the vw_aspnet_MembershipUsers view...'
  EXEC('
  CREATE VIEW [dbo].[vw_aspnet_MembershipUsers]
  AS SELECT [dbo].[aspnet_Membership].[UserId],
            [dbo].[aspnet_Membership].[PasswordFormat],
            [dbo].[aspnet_Membership].[MobilePIN],
            [dbo].[aspnet_Membership].[Email],
            [dbo].[aspnet_Membership].[LoweredEmail],
            [dbo].[aspnet_Membership].[PasswordQuestion],
            [dbo].[aspnet_Membership].[PasswordAnswer],
            [dbo].[aspnet_Membership].[IsApproved],
            [dbo].[aspnet_Membership].[IsLockedOut],
            [dbo].[aspnet_Membership].[CreateDate],
            [dbo].[aspnet_Membership].[LastLoginDate],
            [dbo].[aspnet_Membership].[LastPasswordChangedDate],
            [dbo].[aspnet_Membership].[LastLockoutDate],
            [dbo].[aspnet_Membership].[FailedPasswordAttemptCount],
            [dbo].[aspnet_Membership].[FailedPasswordAttemptWindowStart],
            [dbo].[aspnet_Membership].[FailedPasswordAnswerAttemptCount],
            [dbo].[aspnet_Membership].[FailedPasswordAnswerAttemptWindowStart],
            [dbo].[aspnet_Membership].[Comment],
            [dbo].[aspnet_Users].[ApplicationId],
            [dbo].[aspnet_Users].[UserName],
            [dbo].[aspnet_Users].[MobileAlias],
            [dbo].[aspnet_Users].[IsAnonymous],
            [dbo].[aspnet_Users].[LastActivityDate]
  FROM [dbo].[aspnet_Membership] INNER JOIN [dbo].[aspnet_Users]
      ON [dbo].[aspnet_Membership].[UserId] = [dbo].[aspnet_Users].[UserId]
  ')
END
GO

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

--
--Create Membership schema version
--
DECLARE @command nvarchar(4000)
SET @command = 'GRANT EXECUTE ON [dbo].aspnet_RegisterSchemaVersion TO ' + QUOTENAME(user)
EXECUTE (@command)
GO

EXEC [dbo].aspnet_RegisterSchemaVersion N'Membership', N'1', 1, 1
GO

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

--
--Create Membership roles
--

IF ( NOT EXISTS ( SELECT name
                  FROM sysusers
                  WHERE issqlrole = 1
                  AND name = N'aspnet_Membership_FullAccess'  ) )
EXEC sp_addrole N'aspnet_Membership_FullAccess'

IF ( NOT EXISTS ( SELECT name
                  FROM sysusers
                  WHERE issqlrole = 1
                  AND name = N'aspnet_Membership_BasicAccess'  ) )
EXEC sp_addrole N'aspnet_Membership_BasicAccess'

IF ( NOT EXISTS ( SELECT name
                  FROM sysusers
                  WHERE issqlrole = 1
                  AND name = N'aspnet_Membership_ReportingAccess'  ) )
EXEC sp_addrole N'aspnet_Membership_ReportingAccess'
GO

EXEC sp_addrolemember N'aspnet_Membership_BasicAccess', N'aspnet_Membership_FullAccess'
EXEC sp_addrolemember N'aspnet_Membership_ReportingAccess', N'aspnet_Membership_FullAccess'
GO

--
--Stored Procedure rights for BasicAcess
--
GRANT EXECUTE ON dbo.aspnet_Membership_GetUserByUserId TO aspnet_Membership_BasicAccess
GRANT EXECUTE ON dbo.aspnet_Membership_GetUserByName TO aspnet_Membership_BasicAccess
GRANT EXECUTE ON dbo.aspnet_Membership_GetUserByEmail TO aspnet_Membership_BasicAccess
GRANT EXECUTE ON dbo.aspnet_Membership_GetPassword TO aspnet_Membership_BasicAccess
GRANT EXECUTE ON dbo.aspnet_Membership_GetPasswordWithFormat TO aspnet_Membership_BasicAccess
GRANT EXECUTE ON dbo.aspnet_Membership_UpdateUserInfo TO aspnet_Membership_BasicAccess
GRANT EXECUTE ON dbo.aspnet_Membership_GetNumberOfUsersOnline TO aspnet_Membership_BasicAccess
GRANT EXECUTE ON dbo.aspnet_CheckSchemaVersion TO aspnet_Membership_BasicAccess
GRANT EXECUTE ON dbo.aspnet_RegisterSchemaVersion TO aspnet_Membership_BasicAccess
GRANT EXECUTE ON dbo.aspnet_UnRegisterSchemaVersion TO aspnet_Membership_BasicAccess

--
--Stored Procedure rights for ReportingAccess
--
GRANT EXECUTE ON dbo.aspnet_Membership_GetUserByUserId TO aspnet_Membership_ReportingAccess
GRANT EXECUTE ON dbo.aspnet_Membership_GetUserByName TO aspnet_Membership_ReportingAccess
GRANT EXECUTE ON dbo.aspnet_Membership_GetUserByEmail TO aspnet_Membership_ReportingAccess
GRANT EXECUTE ON dbo.aspnet_Membership_GetAllUsers TO aspnet_Membership_ReportingAccess
GRANT EXECUTE ON dbo.aspnet_Membership_GetNumberOfUsersOnline TO aspnet_Membership_ReportingAccess
GRANT EXECUTE ON dbo.aspnet_Membership_FindUsersByName TO aspnet_Membership_ReportingAccess
GRANT EXECUTE ON dbo.aspnet_Membership_FindUsersByEmail TO aspnet_Membership_ReportingAccess
GRANT EXECUTE ON dbo.aspnet_CheckSchemaVersion TO aspnet_Membership_ReportingAccess
GRANT EXECUTE ON dbo.aspnet_RegisterSchemaVersion TO aspnet_Membership_ReportingAccess
GRANT EXECUTE ON dbo.aspnet_UnRegisterSchemaVersion TO aspnet_Membership_ReportingAccess

--
--Additional stored procedure rights for FullAccess
--
GRANT EXECUTE ON dbo.aspnet_Users_DeleteUser TO aspnet_Membership_FullAccess

GRANT EXECUTE ON dbo.aspnet_Membership_CreateUser TO aspnet_Membership_FullAccess
GRANT EXECUTE ON dbo.aspnet_Membership_SetPassword TO aspnet_Membership_FullAccess
GRANT EXECUTE ON dbo.aspnet_Membership_ResetPassword TO aspnet_Membership_FullAccess
GRANT EXECUTE ON dbo.aspnet_Membership_UpdateUser TO aspnet_Membership_FullAccess
GRANT EXECUTE ON dbo.aspnet_Membership_ChangePasswordQuestionAndAnswer TO aspnet_Membership_FullAccess
GRANT EXECUTE ON dbo.aspnet_Membership_UnlockUser TO aspnet_Membership_FullAccess

--
--View rights
--
GRANT SELECT ON dbo.vw_aspnet_Applications TO aspnet_Membership_ReportingAccess
GRANT SELECT ON dbo.vw_aspnet_Users TO aspnet_Membership_ReportingAccess

GRANT SELECT ON dbo.vw_aspnet_MembershipUsers TO aspnet_Membership_ReportingAccess

DECLARE @command nvarchar(4000)
SET @command = 'REVOKE EXECUTE ON [dbo].aspnet_RegisterSchemaVersion FROM ' + QUOTENAME(user)
EXECUTE (@command)
GO

PRINT '--------------------------------------------'
PRINT 'Completed execution of InstallMembership.SQL'
PRINT '--------------------------------------------'

${this.title}

Code Editor : InstallMembership.sql