Gecko [ www.vortexaion.com ]

Name	Size	Permission	Date
1033	[ DIR ]	drwxrwxrwx	2024-04-13 06:03
1046	[ DIR ]	drwxrwxrwx	2023-09-04 05:52
ASP.NETWebAdminFiles	[ DIR ]	drwxrwxrwx	2019-12-07 10:31
Config	[ DIR ]	drwxrwxrwx	2019-12-07 10:31
MSBuild	[ DIR ]	drwxrwxrwx	2019-12-07 10:31
MUI	[ DIR ]	drwxrwxrwx	2019-12-07 10:14
NativeImages	[ DIR ]	drwxrwxrwx	2025-04-23 04:52
SQL	[ DIR ]	drwxrwxrwx	2019-12-07 15:53
WPF	[ DIR ]	drwxrwxrwx	2025-04-09 22:34
en-US	[ DIR ]	drwxrwxrwx	2023-03-23 12:54
pt-BR	[ DIR ]	drwxrwxrwx	2023-09-04 05:52
Accessibility.dll	30.32 KB	-rw-rw-rw-	2022-06-25 04:18
AddInProcess.exe	35.43 KB	-rwxrwxrwx	2022-06-25 04:18
AddInProcess.exe.config	161 B	-rw-rw-rw-	2019-12-07 10:10
AddInProcess32.exe	35.43 KB	-rwxrwxrwx	2022-06-25 04:18
AddInProcess32.exe.config	161 B	-rw-rw-rw-	2019-12-07 10:10
AddInUtil.exe	35.93 KB	-rwxrwxrwx	2022-06-25 04:18
AddInUtil.exe.config	161 B	-rw-rw-rw-	2019-12-07 10:10
AdoNetDiag.dll	208.41 KB	-rw-rw-rw-	2022-06-25 04:16
AppLaunch.exe	106.48 KB	-rwxrwxrwx	2022-06-25 04:16
Aspnet.config	437 B	-rw-rw-rw-	2019-12-07 10:12
Aspnet_perf.dll	42.03 KB	-rw-rw-rw-	2024-09-17 02:58
CLR-ETW.man	315.83 KB	-rw-rw-rw-	2019-12-07 10:10
CORPerfMonExt.dll	138.41 KB	-rw-rw-rw-	2022-08-29 22:36
CasPol.exe	98.98 KB	-rwxrwxrwx	2022-06-25 04:16
ComSvcConfig.exe	163.93 KB	-rwxrwxrwx	2022-06-25 04:18
Culture.dll	55.41 KB	-rw-rw-rw-	2022-06-25 04:16
CustomMarshalers.dll	105.91 KB	-rw-rw-rw-	2022-06-25 04:16
DataSvcUtil.exe	64.41 KB	-rwxrwxrwx	2022-06-25 04:18
DataSvcUtil.exe.config	156 B	-rw-rw-rw-	2019-12-07 10:10
EdmGen.exe	88.92 KB	-rwxrwxrwx	2022-06-25 04:18
EventLogMessages.dll	780.42 KB	-rw-rw-rw-	2022-06-25 04:16
FileTracker.dll	276.89 KB	-rw-rw-rw-	2022-06-25 04:16
ISymWrapper.dll	69.39 KB	-rw-rw-rw-	2022-06-25 04:16
InstallCommon.sql	24.03 KB	-rw-rw-rw-	2019-12-07 10:12
InstallMembership.sql	54.93 KB	-rw-rw-rw-	2019-12-07 10:12
InstallPersistSqlState.sql	53.37 KB	-rw-rw-rw-	2019-12-07 10:12
InstallPersonalization.sql	34.13 KB	-rw-rw-rw-	2019-12-07 10:12
InstallProfile.SQL	20.4 KB	-rw-rw-rw-	2019-12-07 10:12
InstallRoles.sql	33.46 KB	-rw-rw-rw-	2019-12-07 10:12
InstallSqlState.sql	53.15 KB	-rw-rw-rw-	2019-12-07 10:12
InstallSqlStateTemplate.sql	54.92 KB	-rw-rw-rw-	2019-12-07 10:12
InstallUtil.exe	33.95 KB	-rwxrwxrwx	2022-06-25 04:16
InstallUtil.exe.config	182 B	-rw-rw-rw-	2019-12-07 10:10
InstallUtilLib.dll	127.42 KB	-rw-rw-rw-	2022-06-25 04:16
InstallWebEventSqlProvider.sql	6.31 KB	-rw-rw-rw-	2019-12-07 10:12
MSBuild.exe	246.4 KB	-rwxrwxrwx	2022-06-25 04:16
MSBuild.rsp	732 B	-rw-rw-rw-	2019-12-07 10:10
Microsoft.Activities.Build.dll	46.91 KB	-rw-rw-rw-	2022-06-25 04:18
Microsoft.Build.Conversion.v4.0.dll	77.42 KB	-rw-rw-rw-	2022-06-25 04:18
Microsoft.Build.Engine.dll	637.91 KB	-rw-rw-rw-	2022-06-25 04:18
Microsoft.Build.Framework.dll	91.91 KB	-rw-rw-rw-	2022-06-25 04:18
Microsoft.Build.Tasks.v4.0.dll	1.12 MB	-rw-rw-rw-	2022-06-25 04:18
Microsoft.Build.Utilities.v4.0.dll	257.41 KB	-rw-rw-rw-	2022-06-25 04:18
Microsoft.Build.dll	1.34 MB	-rw-rw-rw-	2022-06-25 04:18
Microsoft.Build.xsd	2.3 KB	-rw-rw-rw-	2019-12-07 10:12
Microsoft.CSharp.dll	471.34 KB	-rw-rw-rw-	2022-06-25 04:18
Microsoft.CSharp.targets	23.06 KB	-rw-rw-rw-	2019-12-07 10:10
Microsoft.Common.OverrideTasks	6.15 KB	-rw-rw-rw-	2019-12-07 10:10
Microsoft.Common.Tasks	14.55 KB	-rw-rw-rw-	2019-12-07 10:10
Microsoft.Common.targets	256.39 KB	-rw-rw-rw-	2019-12-07 10:10
Microsoft.Data.Entity.Build.Tasks.dll	45.92 KB	-rw-rw-rw-	2022-06-25 04:18
Microsoft.Data.Entity.targets	6.35 KB	-rw-rw-rw-	2019-12-07 10:10
Microsoft.Internal.Tasks.Dataflow.dll	174.92 KB	-rw-rw-rw-	2022-06-25 04:18
Microsoft.JScript.dll	730.91 KB	-rw-rw-rw-	2022-06-25 04:18
Microsoft.JScript.tlb	57 KB	-rw-rw-rw-	2022-06-25 00:17
Microsoft.NETFramework.props	11.68 KB	-rw-rw-rw-	2019-12-07 10:10
Microsoft.NETFramework.targets	7.99 KB	-rw-rw-rw-	2019-12-07 10:10
Microsoft.ServiceModel.targets	9.55 KB	-rw-rw-rw-	2019-12-07 10:10
Microsoft.Transactions.Bridge.Dtc.dll	125.39 KB	-rw-rw-rw-	2022-06-25 04:16
Microsoft.Transactions.Bridge.dll	381.85 KB	-rw-rw-rw-	2022-06-25 04:18
Microsoft.VisualBasic.Activities.Compiler.dll	3.64 MB	-rw-rw-rw-	2022-06-25 04:16
Microsoft.VisualBasic.Compatibility.Data.dll	108.42 KB	-rw-rw-rw-	2022-06-25 04:18
Microsoft.VisualBasic.Compatibility.dll	480.42 KB	-rw-rw-rw-	2022-06-25 04:18
Microsoft.VisualBasic.dll	620.84 KB	-rw-rw-rw-	2022-06-25 04:18
Microsoft.VisualBasic.targets	22.37 KB	-rw-rw-rw-	2019-12-07 10:10
Microsoft.VisualC.Dll	29.7 KB	-rw-rw-rw-	2019-12-07 10:10
Microsoft.VisualC.STLCLR.dll	49.73 KB	-rw-rw-rw-	2019-12-07 10:10
Microsoft.Win32.Primitives.dll	23.32 KB	-rw-rw-rw-	2022-06-25 04:18
Microsoft.WinFx.targets	41.35 KB	-rw-rw-rw-	2019-12-07 10:10
Microsoft.Windows.ApplicationServer.Applications.45.man	707.36 KB	-rw-rw-rw-	2019-12-07 10:10
Microsoft.Windows.ApplicationServer.Applications.dll	132.34 KB	-rw-rw-rw-	2022-06-25 04:18
Microsoft.Workflow.Compiler.exe	26.46 KB	-rwxrwxrwx	2022-06-25 04:18
Microsoft.Workflow.Compiler.exe.config	144 B	-rw-rw-rw-	2019-12-07 10:10
Microsoft.WorkflowBuildExtensions.targets	7.36 KB	-rw-rw-rw-	2019-12-07 10:10
Microsoft.Xaml.targets	19.43 KB	-rw-rw-rw-	2019-12-07 10:10
MmcAspExt.dll	107.91 KB	-rw-rw-rw-	2022-06-25 04:16
PerfCounter.dll	253.41 KB	-rw-rw-rw-	2022-06-25 04:16
RegAsm.exe	56.46 KB	-rwxrwxrwx	2022-06-25 04:16
RegSvcs.exe	37.96 KB	-rwxrwxrwx	2022-06-25 04:16
SMDiagnostics.dll	66.87 KB	-rw-rw-rw-	2024-03-28 03:55
SMSvcHost.exe	129.41 KB	-rwxrwxrwx	2022-06-25 04:18
SMSvcHost.exe.config	2.21 KB	-rw-rw-rw-	2019-12-07 10:12
SOS.dll	836.54 KB	-rw-rw-rw-	2025-03-20 01:42
SbsNclPerf.dll	17.92 KB	-rw-rw-rw-	2022-06-25 04:16
ServiceModelEvents.dll	12.41 KB	-rw-rw-rw-	2022-06-25 04:16
ServiceModelInstallRC.dll	12.41 KB	-rw-rw-rw-	2022-06-25 04:16
ServiceModelPerformanceCounters.dll	98.41 KB	-rw-rw-rw-	2022-06-25 04:16
ServiceModelPerformanceCounters.man	126.02 KB	-rw-rw-rw-	2019-12-07 10:10
ServiceModelReg.exe	283.47 KB	-rwxrwxrwx	2022-06-25 04:16
ServiceModelRegUI.dll	12.41 KB	-rw-rw-rw-	2022-06-25 04:16
ServiceMonikerSupport.dll	27.92 KB	-rw-rw-rw-	2024-03-28 04:35
System.Activities.Core.Presentation.dll	691.91 KB	-rw-rw-rw-	2022-06-25 04:18
System.Activities.DurableInstancing.dll	133.85 KB	-rw-rw-rw-	2022-06-25 04:18
System.Activities.Presentation.dll	2.02 MB	-rw-rw-rw-	2022-08-30 01:39
System.Activities.dll	1.46 MB	-rw-rw-rw-	2024-03-28 03:55
System.AddIn.Contract.dll	45.41 KB	-rw-rw-rw-	2022-06-25 04:18
System.AddIn.dll	153.92 KB	-rw-rw-rw-	2022-06-25 04:18
System.AppContext.dll	23.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.Collections.Concurrent.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Collections.NonGeneric.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Collections.Specialized.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Collections.dll	24.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.ComponentModel.Annotations.dll	24.81 KB	-rw-rw-rw-	2022-06-25 04:18
System.ComponentModel.Composition.dll	292.84 KB	-rw-rw-rw-	2022-06-25 04:18
System.ComponentModel.DataAnnotations.dll	119.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.ComponentModel.EventBasedAsync.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.ComponentModel.Primitives.dll	24.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.ComponentModel.TypeConverter.dll	25.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.ComponentModel.dll	23.81 KB	-rw-rw-rw-	2022-06-25 04:18
System.Configuration.Install.dll	95.85 KB	-rw-rw-rw-	2022-06-25 04:18
System.Configuration.dll	406.35 KB	-rw-rw-rw-	2022-06-25 04:18
System.Console.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Core.dll	1.48 MB	-rw-rw-rw-	2024-12-11 05:23
System.Data.Common.dll	24.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.Data.DataSetExtensions.dll	65.34 KB	-rw-rw-rw-	2022-06-25 04:18
System.Data.Entity.Design.dll	1.03 MB	-rw-rw-rw-	2022-06-25 04:18
System.Data.Entity.dll	3.84 MB	-rw-rw-rw-	2022-06-25 04:18
System.Data.Linq.dll	666.42 KB	-rw-rw-rw-	2022-06-25 04:18
System.Data.OracleClient.dll	494.89 KB	-rw-rw-rw-	2022-06-25 04:16
System.Data.Services.Client.dll	428.42 KB	-rw-rw-rw-	2022-06-25 04:18
System.Data.Services.Design.dll	164.41 KB	-rw-rw-rw-	2022-06-25 04:18
System.Data.Services.dll	650.89 KB	-rw-rw-rw-	2022-06-25 04:18
System.Data.SqlXml.dll	712.84 KB	-rw-rw-rw-	2022-06-25 04:18
System.Data.dll	3.37 MB	-rw-rw-rw-	2023-11-30 04:23
System.Deployment.dll	1.52 MB	-rw-rw-rw-	2023-07-06 23:32
System.Design.dll	4.79 MB	-rw-rw-rw-	2022-06-25 04:18
System.Device.dll	57.42 KB	-rw-rw-rw-	2022-06-25 04:18
System.Diagnostics.Contracts.dll	24.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.Diagnostics.Debug.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Diagnostics.FileVersionInfo.dll	23.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.Diagnostics.Process.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Diagnostics.StackTrace.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Diagnostics.TextWriterTraceListener.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Diagnostics.Tools.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Diagnostics.TraceSource.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Diagnostics.Tracing.dll	33.84 KB	-rw-rw-rw-	2022-06-25 04:18
System.DirectoryServices.AccountManagement.dll	287.05 KB	-rw-rw-rw-	2024-09-17 02:59
System.DirectoryServices.Protocols.dll	191.84 KB	-rw-rw-rw-	2022-06-25 04:18
System.DirectoryServices.dll	411.99 KB	-rw-rw-rw-	2024-09-17 02:59
System.Drawing.Design.dll	124.84 KB	-rw-rw-rw-	2022-06-25 04:18
System.Drawing.Primitives.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Drawing.dll	582.34 KB	-rw-rw-rw-	2022-06-25 04:18
System.Drawing.tlb	8.5 KB	-rw-rw-rw-	2022-06-25 00:23
System.Dynamic.Runtime.dll	24.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.Dynamic.dll	122.85 KB	-rw-rw-rw-	2022-06-25 04:18
System.EnterpriseServices.Thunk.dll	103.91 KB	-rw-rw-rw-	2022-06-25 04:16
System.EnterpriseServices.Wrapper.dll	132 KB	-rw-rw-rw-	2022-06-25 00:09
System.EnterpriseServices.dll	229.92 KB	-rw-rw-rw-	2022-06-25 04:16
System.EnterpriseServices.tlb	33.5 KB	-rw-rw-rw-	2022-06-25 00:18
System.Globalization.Calendars.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Globalization.Extensions.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Globalization.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.IO.Compression.FileSystem.dll	26.91 KB	-rw-rw-rw-	2022-06-25 04:18
System.IO.Compression.ZipFile.dll	23.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.IO.Compression.dll	66.07 KB	-rw-rw-rw-	2024-08-30 06:48
System.IO.FileSystem.DriveInfo.dll	23.34 KB	-rw-rw-rw-	2022-06-25 04:18
System.IO.FileSystem.Primitives.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.IO.FileSystem.Watcher.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.IO.FileSystem.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.IO.IsolatedStorage.dll	23.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.IO.Log.dll	124.91 KB	-rw-rw-rw-	2022-06-25 04:18
System.IO.MemoryMappedFiles.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.IO.Pipes.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.IO.UnmanagedMemoryStream.dll	23.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.IO.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.IdentityModel.Selectors.dll	136.34 KB	-rw-rw-rw-	2022-06-25 04:18
System.IdentityModel.Services.dll	187.53 KB	-rw-rw-rw-	2024-03-28 03:55
System.IdentityModel.dll	1.04 MB	-rw-rw-rw-	2024-03-28 03:55
System.Linq.Expressions.dll	24.8 KB	-rw-rw-rw-	2022-06-25 04:18
System.Linq.Parallel.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Linq.Queryable.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Linq.dll	23.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.Management.Instrumentation.dll	136.41 KB	-rw-rw-rw-	2022-06-25 04:18
System.Management.dll	401.35 KB	-rw-rw-rw-	2022-06-25 04:18
System.Messaging.dll	266.34 KB	-rw-rw-rw-	2022-06-25 04:18
System.Net.Http.Rtc.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Net.Http.WebRequest.dll	44.84 KB	-rw-rw-rw-	2022-06-25 04:18
System.Net.Http.dll	194.85 KB	-rw-rw-rw-	2022-06-25 04:18
System.Net.NameResolution.dll	23.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.Net.NetworkInformation.dll	24.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Net.Ping.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Net.Primitives.dll	24.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.Net.Requests.dll	23.84 KB	-rw-rw-rw-	2022-06-25 04:18
System.Net.Security.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Net.Sockets.dll	24.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.Net.WebHeaderCollection.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Net.WebSockets.Client.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Net.WebSockets.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Net.dll	246.35 KB	-rw-rw-rw-	2022-06-25 04:18
System.Numerics.Vectors.dll	25.84 KB	-rw-rw-rw-	2022-06-25 04:18
System.Numerics.dll	130.84 KB	-rw-rw-rw-	2022-06-25 04:18
System.ObjectModel.dll	24.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.Reflection.Emit.ILGeneration.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Reflection.Emit.Lightweight.dll	23.81 KB	-rw-rw-rw-	2022-06-25 04:18
System.Reflection.Emit.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Reflection.Extensions.dll	23.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.Reflection.Primitives.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Reflection.context.dll	100.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Reflection.dll	24.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.Resources.Reader.dll	23.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.Resources.ResourceManager.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Resources.Writer.dll	23.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.Runtime.Caching.dll	102.92 KB	-rw-rw-rw-	2024-08-30 06:48
System.Runtime.CompilerServices.VisualC.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Runtime.DurableInstancing.dll	163.84 KB	-rw-rw-rw-	2022-06-25 04:18
System.Runtime.Extensions.dll	23.84 KB	-rw-rw-rw-	2022-06-25 04:18
System.Runtime.Handles.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Runtime.InteropServices.RuntimeInformation.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Runtime.InteropServices.WindowsRuntime.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Runtime.InteropServices.dll	26.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Runtime.Numerics.dll	23.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.Runtime.Remoting.dll	334.97 KB	-rw-rw-rw-	2023-11-30 03:50
System.Runtime.Serialization.Formatters.Soap.dll	133.85 KB	-rw-rw-rw-	2022-06-25 04:18
System.Runtime.Serialization.Formatters.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Runtime.Serialization.Json.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Runtime.Serialization.Primitives.dll	23.83 KB	-rw-rw-rw-	2022-06-25 04:18
System.Runtime.Serialization.Xml.dll	24.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.Runtime.Serialization.dll	1 MB	-rw-rw-rw-	2024-03-28 03:55
System.Runtime.WindowsRuntime.UI.Xaml.dll	65.84 KB	-rw-rw-rw-	2022-06-25 04:18
System.Runtime.WindowsRuntime.dll	151.84 KB	-rw-rw-rw-	2022-06-25 04:18
System.Runtime.dll	31.84 KB	-rw-rw-rw-	2022-06-25 04:18
System.Security.Claims.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Security.Cryptography.Algorithms.dll	24.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.Security.Cryptography.Csp.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Security.Cryptography.Encoding.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Security.Cryptography.Primitives.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Security.Cryptography.X509Certificates.dll	24.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Security.Principal.dll	23.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.Security.SecureString.dll	23.34 KB	-rw-rw-rw-	2022-06-25 04:18
System.Security.dll	314.85 KB	-rw-rw-rw-	2022-06-25 04:18
System.ServiceModel.Activation.dll	191.91 KB	-rw-rw-rw-	2022-06-25 04:18
System.ServiceModel.Activities.dll	543.41 KB	-rw-rw-rw-	2022-06-25 04:18
System.ServiceModel.Channels.dll	148.43 KB	-rw-rw-rw-	2024-03-28 03:55
System.ServiceModel.Discovery.dll	295.43 KB	-rw-rw-rw-	2024-03-28 03:55
System.ServiceModel.Duplex.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.ServiceModel.Http.dll	23.8 KB	-rw-rw-rw-	2022-06-25 04:18
System.ServiceModel.Internals.dll	242.87 KB	-rw-rw-rw-	2024-03-28 03:55
System.ServiceModel.NetTcp.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.ServiceModel.Primitives.dll	28.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.ServiceModel.Routing.dll	121.92 KB	-rw-rw-rw-	2022-06-25 04:18
System.ServiceModel.Security.dll	24.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.ServiceModel.ServiceMoniker40.dll	16.92 KB	-rw-rw-rw-	2022-06-25 04:18
System.ServiceModel.WasHosting.dll	33.44 KB	-rw-rw-rw-	2024-03-28 03:55
System.ServiceModel.Web.dll	316.34 KB	-rw-rw-rw-	2022-06-25 04:18
System.ServiceModel.dll	6.09 MB	-rw-rw-rw-	2024-03-28 03:55
System.ServiceProcess.dll	130.84 KB	-rw-rw-rw-	2022-06-25 04:18
System.Text.Encoding.Extensions.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Text.Encoding.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Text.RegularExpressions.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Threading.Overlapped.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Threading.Tasks.Parallel.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Threading.Tasks.dll	24.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Threading.Thread.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Threading.ThreadPool.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Threading.Timer.dll	23.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.Threading.dll	24.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.Transactions.dll	301.92 KB	-rw-rw-rw-	2022-06-25 04:16
System.ValueTuple.dll	23.84 KB	-rw-rw-rw-	2022-06-25 04:18
System.Web.Abstractions.dll	16.41 KB	-rw-rw-rw-	2022-06-25 04:18
System.Web.ApplicationServices.dll	64.52 KB	-rw-rw-rw-	2024-09-17 02:59
System.Web.DataVisualization.Design.dll	97.41 KB	-rw-rw-rw-	2022-06-25 04:18
System.Web.DataVisualization.dll	1.61 MB	-rw-rw-rw-	2022-06-25 04:18
System.Web.DynamicData.Design.dll	37.91 KB	-rw-rw-rw-	2022-06-25 04:18
System.Web.DynamicData.dll	236.41 KB	-rw-rw-rw-	2022-06-25 04:18
System.Web.Entity.Design.dll	166.91 KB	-rw-rw-rw-	2022-06-25 04:18
System.Web.Entity.dll	155.91 KB	-rw-rw-rw-	2022-06-25 04:18
System.Web.Extensions.Design.dll	342.41 KB	-rw-rw-rw-	2022-06-25 04:18
System.Web.Extensions.dll	1.76 MB	-rw-rw-rw-	2024-09-17 02:59
System.Web.Mobile.dll	805.41 KB	-rw-rw-rw-	2022-06-25 04:18
System.Web.RegularExpressions.dll	97.91 KB	-rw-rw-rw-	2022-06-25 04:18
System.Web.Routing.dll	16.41 KB	-rw-rw-rw-	2022-06-25 04:18
System.Web.Services.dll	822.34 KB	-rw-rw-rw-	2022-06-25 04:18
System.Web.dll	5.15 MB	-rw-rw-rw-	2024-09-17 02:58
System.Web.tlb	7 KB	-rw-rw-rw-	2022-06-25 00:22
System.Windows.Forms.DataVisualization.Design.dll	74.41 KB	-rw-rw-rw-	2022-06-25 04:18
System.Windows.Forms.DataVisualization.dll	1.64 MB	-rw-rw-rw-	2022-06-25 04:18
System.Windows.Forms.dll	5.72 MB	-rw-rw-rw-	2024-06-01 06:20
System.Windows.Forms.tlb	85 KB	-rw-rw-rw-	2022-06-25 00:21
System.Windows.dll	25.85 KB	-rw-rw-rw-	2022-06-25 04:18
System.Workflow.Activities.dll	1019.42 KB	-rw-rw-rw-	2022-06-25 04:18
System.Workflow.ComponentModel.dll	1.48 MB	-rw-rw-rw-	2022-06-25 04:18
System.Workflow.Runtime.dll	503.41 KB	-rw-rw-rw-	2022-06-25 04:18
System.WorkflowServices.dll	434.42 KB	-rw-rw-rw-	2022-06-25 04:18
System.XML.dll	2.51 MB	-rw-rw-rw-	2022-06-25 04:18
System.Xaml.Hosting.dll	36.41 KB	-rw-rw-rw-	2022-06-25 04:18
System.Xaml.dll	619.63 KB	-rw-rw-rw-	2024-12-11 05:23
System.Xml.Linq.dll	154.85 KB	-rw-rw-rw-	2022-06-25 04:18
System.Xml.ReaderWriter.dll	24.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.Xml.Serialization.dll	39.85 KB	-rw-rw-rw-	2022-06-25 04:18
System.Xml.XDocument.dll	23.84 KB	-rw-rw-rw-	2022-06-25 04:18
System.Xml.XPath.XDocument.dll	23.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.Xml.XPath.dll	23.82 KB	-rw-rw-rw-	2022-06-25 04:18
System.Xml.XmlDocument.dll	24.32 KB	-rw-rw-rw-	2022-06-25 04:18
System.Xml.XmlSerializer.dll	24.34 KB	-rw-rw-rw-	2022-06-25 04:18
System.dll	3.38 MB	-rw-rw-rw-	2025-03-20 01:37
System.tlb	70.5 KB	-rw-rw-rw-	2022-06-25 00:02
TLBREF.DLL	128.41 KB	-rw-rw-rw-	2022-06-25 04:16
ThirdPartyNotices.txt	60.27 KB	-rw-rw-rw-	2019-12-07 10:10
UnInstallProfile.SQL	4.65 KB	-rw-rw-rw-	2019-12-07 10:12
UninstallCommon.sql	3.8 KB	-rw-rw-rw-	2019-12-07 10:12
UninstallMembership.sql	6.75 KB	-rw-rw-rw-	2019-12-07 10:12
UninstallPersistSqlState.sql	9.96 KB	-rw-rw-rw-	2019-12-07 10:12
UninstallPersonalization.sql	7.31 KB	-rw-rw-rw-	2019-12-07 10:12
UninstallRoles.sql	5.73 KB	-rw-rw-rw-	2019-12-07 10:12
UninstallSqlState.sql	9.46 KB	-rw-rw-rw-	2019-12-07 10:12
UninstallSqlStateTemplate.sql	11.52 KB	-rw-rw-rw-	2019-12-07 10:12
UninstallWebEventSqlProvider.sql	2.94 KB	-rw-rw-rw-	2019-12-07 10:12
WMINet_Utils.dll	180.41 KB	-rw-rw-rw-	2022-06-25 04:16
Workflow.Targets	6.96 KB	-rw-rw-rw-	2019-12-07 10:10
Workflow.VisualBasic.Targets	8.39 KB	-rw-rw-rw-	2019-12-07 10:10
WorkflowServiceHostPerformanceCounters.dll	96.41 KB	-rw-rw-rw-	2022-06-25 04:16
WorkflowServiceHostPerformanceCounters.man	42.27 KB	-rw-rw-rw-	2019-12-07 10:10
WsatConfig.exe	143.45 KB	-rwxrwxrwx	2022-06-25 04:18
XPThemes.manifest	474 B	-rw-rw-rw-	2019-12-07 10:10
XamlBuildTask.dll	123.91 KB	-rw-rw-rw-	2022-06-25 04:18
XsdBuildTask.dll	60.41 KB	-rw-rw-rw-	2022-06-25 04:18
adonetdiag.mof	7.35 KB	-rw-rw-rw-	2019-12-07 10:10
adonetdiag.mof.uninstall	1.95 KB	-rw-rw-rw-	2019-12-07 10:10
alink.dll	145.91 KB	-rw-rw-rw-	2022-06-25 04:16
applaunch.exe.config	281 B	-rw-rw-rw-	2019-12-07 10:12
aspnet_compiler.exe	47.91 KB	-rwxrwxrwx	2022-06-25 04:16
aspnet_filter.dll	34.91 KB	-rw-rw-rw-	2022-06-25 04:16
aspnet_isapi.dll	21.91 KB	-rw-rw-rw-	2022-06-25 04:16
aspnet_perf.h	7.01 KB	-rw-rw-rw-	2019-12-07 10:10
aspnet_perf.ini	974.12 KB	-rw-rw-rw-	2019-12-07 10:10
aspnet_perf2.ini	972.21 KB	-rw-rw-rw-	2019-12-07 10:10
aspnet_rc.dll	82.91 KB	-rw-rw-rw-	2022-06-25 04:16
aspnet_regbrowsers.exe	37.95 KB	-rwxrwxrwx	2024-06-01 05:51
aspnet_regiis.exe	41.55 KB	-rwxrwxrwx	2024-06-01 05:51
aspnet_regsql.exe	118.05 KB	-rwxrwxrwx	2024-06-01 06:04
aspnet_state.exe	47.43 KB	-rwxrwxrwx	2022-06-25 04:16
aspnet_state_perf.h	318 B	-rw-rw-rw-	2019-12-07 10:10
aspnet_state_perf.ini	41.99 KB	-rw-rw-rw-	2019-12-07 10:10
aspnet_wp.exe	46.05 KB	-rwxrwxrwx	2024-09-17 02:58
caspol.exe.config	368 B	-rw-rw-rw-	2019-12-07 10:12
clientexclusionlist.xml	35.1 KB	-rw-rw-rw-	2019-12-07 10:10
clr.dll	9.54 MB	-rw-rw-rw-	2025-03-20 01:42
clrcompression.dll	141.53 KB	-rw-rw-rw-	2024-06-25 04:37
clretwrc.dll	226.91 KB	-rw-rw-rw-	2022-06-25 04:16
clrjit.dll	1.17 MB	-rw-rw-rw-	2025-03-20 01:42
compatjit.dll	1.15 MB	-rw-rw-rw-	2025-03-20 01:42
csc.exe	2.45 MB	-rwxrwxrwx	2024-03-12 04:53
csc.exe.config	182 B	-rw-rw-rw-	2019-12-07 10:10
csc.rsp	1.3 KB	-rw-rw-rw-	2019-12-07 10:10
cvtres.exe	45.99 KB	-rwxrwxrwx	2022-06-24 23:31
cvtres.exe.config	281 B	-rw-rw-rw-	2019-12-07 10:10
default.win32manifest	490 B	-rw-rw-rw-	2019-12-07 10:10
dfdll.dll	210.44 KB	-rw-rw-rw-	2023-07-07 00:02
dfsvc.exe	17.91 KB	-rwxrwxrwx	2022-06-25 04:18
dfsvc.exe.config	893 B	-rw-rw-rw-	2019-12-07 10:12
diasymreader.dll	1.24 MB	-rw-rw-rw-	2024-12-03 12:46
dv_aspnetmmc.chm	112.43 KB	-rw-rw-rw-	2019-12-07 10:10
fusion.dll	100.42 KB	-rw-rw-rw-	2022-06-25 04:16
ilasm.exe	340.46 KB	-rwxrwxrwx	2022-09-15 04:38
ilasm.exe.config	223 B	-rw-rw-rw-	2019-12-07 10:12
jsc.exe	39.91 KB	-rwxrwxrwx	2022-06-25 04:18
jsc.exe.config	281 B	-rw-rw-rw-	2019-12-07 10:12
locale.nlp	409.8 KB	-rw-rw-rw-	2019-12-07 10:10
msbuild.exe.config	1.69 KB	-rw-rw-rw-	2019-12-07 10:10
mscordacwks.dll	1.45 MB	-rw-rw-rw-	2025-03-20 01:42
mscordbi.dll	1.31 MB	-rw-rw-rw-	2025-03-20 01:42
mscoree.tlb	31 KB	-rw-rw-rw-	2022-06-25 00:09
mscoreei.dll	594.91 KB	-rw-rw-rw-	2022-08-29 22:36
mscoreeis.dll	26.91 KB	-rw-rw-rw-	2022-06-25 04:16
mscorlib.dll	5.19 MB	-rw-rw-rw-	2025-03-20 01:42
mscorlib.tlb	505.53 KB	-rw-rw-rw-	2019-12-07 10:10
mscorpe.dll	97.42 KB	-rw-rw-rw-	2022-06-25 04:16
mscorpehost.dll	167.04 KB	-rw-rw-rw-	2024-06-01 05:51
mscorrc.dll	382.91 KB	-rw-rw-rw-	2022-06-25 04:16
mscorsecimpl.dll	116.42 KB	-rw-rw-rw-	2022-06-25 04:16
mscorsn.dll	22.91 KB	-rw-rw-rw-	2022-06-25 04:16
mscorsvc.dll	464.41 KB	-rw-rw-rw-	2022-08-29 22:36
mscorsvw.exe	135.46 KB	-rwxrwxrwx	2022-08-29 22:36
netstandard.dll	99.34 KB	-rw-rw-rw-	2022-06-25 04:18
ngen.exe	170.98 KB	-rwxrwxrwx	2022-08-29 22:36
ngen.log	964.54 KB	-rw-rw-rw-	2025-08-05 00:51
ngen.old.log	1 MB	-rw-rw-rw-	2025-04-03 00:37
ngentask.exe	77.97 KB	-rwxrwxrwx	2022-06-25 04:16
ngentasklauncher.dll	23.39 KB	-rw-rw-rw-	2022-06-25 04:16
normidna.nlp	57.95 KB	-rw-rw-rw-	2019-12-07 10:10
normnfc.nlp	45.97 KB	-rw-rw-rw-	2019-12-07 10:10
normnfd.nlp	39.62 KB	-rw-rw-rw-	2019-12-07 10:10
normnfkc.nlp	66.22 KB	-rw-rw-rw-	2019-12-07 10:10
normnfkd.nlp	60.27 KB	-rw-rw-rw-	2019-12-07 10:10
peverify.dll	232.05 KB	-rw-rw-rw-	2025-03-20 01:42
regasm.exe.config	281 B	-rw-rw-rw-	2019-12-07 10:12
regsvcs.exe.config	223 B	-rw-rw-rw-	2019-12-07 10:12
sort00001000.dll	851.25 KB	-rw-rw-rw-	2024-07-02 01:33
sort00060101.dll	73.26 KB	-rw-rw-rw-	2024-07-02 01:33
sort00060101.nlp	2.82 MB	-rw-rw-rw-	2024-07-02 01:33
sysglobl.dll	124.35 KB	-rw-rw-rw-	2022-06-25 04:18
system.componentmodel.composition.registration.dll	56.85 KB	-rw-rw-rw-	2022-06-25 04:18
vbc.exe	3.13 MB	-rwxrwxrwx	2024-06-01 05:51
vbc.exe.config	182 B	-rw-rw-rw-	2019-12-07 10:10
vbc.rsp	1.43 KB	-rw-rw-rw-	2019-12-07 10:10
webengine.dll	22.04 KB	-rw-rw-rw-	2024-09-17 02:58
webengine4.dll	618.55 KB	-rw-rw-rw-	2024-09-17 02:58

Rename

/**********************************************************************/
/* InstallRoles.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 InstallRoles.SQL'
PRINT '--------------------------------------'
GO

SET QUOTED_IDENTIFIER OFF -- We don't use quoted identifiers
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_Roles')
                  AND (type = 'U')))
BEGIN
  PRINT 'Creating the aspnet_Roles table...'
  CREATE TABLE dbo.aspnet_Roles (
        ApplicationId    uniqueidentifier    NOT NULL FOREIGN KEY REFERENCES dbo.aspnet_Applications(ApplicationId),
        RoleId           uniqueidentifier    PRIMARY KEY  NONCLUSTERED DEFAULT NEWID(),
        RoleName         nvarchar(256)       NOT NULL,
        LoweredRoleName  nvarchar(256)       NOT NULL,
        Description      nvarchar(256)       )
 CREATE UNIQUE  CLUSTERED  INDEX aspnet_Roles_index1 ON  dbo.aspnet_Roles(ApplicationId, LoweredRoleName)
END
GO

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

IF (NOT EXISTS (SELECT name
                FROM sysobjects
                WHERE (name = N'aspnet_UsersInRoles')
                  AND (type = 'U')))
BEGIN
  PRINT 'Creating the aspnet_UsersInRoles table...'
  CREATE TABLE dbo.aspnet_UsersInRoles (
        UserId     uniqueidentifier NOT NULL PRIMARY KEY(UserId, RoleId) FOREIGN KEY REFERENCES dbo.aspnet_Users (UserId),
        RoleId     uniqueidentifier NOT NULL FOREIGN KEY REFERENCES dbo.aspnet_Roles (RoleId))

CREATE INDEX aspnet_UsersInRoles_index ON  dbo.aspnet_UsersInRoles(RoleId)
END

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_UsersInRoles_IsUserInRole')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_UsersInRoles_IsUserInRole
GO

CREATE PROCEDURE dbo.aspnet_UsersInRoles_IsUserInRole
    @ApplicationName  nvarchar(256),
    @UserName         nvarchar(256),
    @RoleName         nvarchar(256)
AS
BEGIN
    DECLARE @ApplicationId uniqueidentifier
    SELECT  @ApplicationId = NULL
    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
    IF (@ApplicationId IS NULL)
        RETURN(2)
    DECLARE @UserId uniqueidentifier
    SELECT  @UserId = NULL
    DECLARE @RoleId uniqueidentifier
    SELECT  @RoleId = NULL

SELECT  @UserId = UserId
    FROM    dbo.aspnet_Users
    WHERE   LoweredUserName = LOWER(@UserName) AND ApplicationId = @ApplicationId

IF (@UserId IS NULL)
        RETURN(2)

SELECT  @RoleId = RoleId
    FROM    dbo.aspnet_Roles
    WHERE   LoweredRoleName = LOWER(@RoleName) AND ApplicationId = @ApplicationId

IF (@RoleId IS NULL)
        RETURN(3)

IF (EXISTS( SELECT * FROM dbo.aspnet_UsersInRoles WHERE  UserId = @UserId AND RoleId = @RoleId))
        RETURN(1)
    ELSE
        RETURN(0)
END
GO

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

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_UsersInRoles_GetRolesForUser')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_UsersInRoles_GetRolesForUser
GO

CREATE PROCEDURE dbo.aspnet_UsersInRoles_GetRolesForUser
    @ApplicationName  nvarchar(256),
    @UserName         nvarchar(256)
AS
BEGIN
    DECLARE @ApplicationId uniqueidentifier
    SELECT  @ApplicationId = NULL
    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
    IF (@ApplicationId IS NULL)
        RETURN(1)
    DECLARE @UserId uniqueidentifier
    SELECT  @UserId = NULL

SELECT  @UserId = UserId
    FROM    dbo.aspnet_Users
    WHERE   LoweredUserName = LOWER(@UserName) AND ApplicationId = @ApplicationId

IF (@UserId IS NULL)
        RETURN(1)

SELECT r.RoleName
    FROM   dbo.aspnet_Roles r, dbo.aspnet_UsersInRoles ur
    WHERE  r.RoleId = ur.RoleId AND r.ApplicationId = @ApplicationId AND ur.UserId = @UserId
    ORDER BY r.RoleName
    RETURN (0)
END
GO

/*************************************************************/
/*************************************************************/
IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_Roles_CreateRole')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_Roles_CreateRole
GO
CREATE PROCEDURE dbo.aspnet_Roles_CreateRole
    @ApplicationName  nvarchar(256),
    @RoleName         nvarchar(256)
AS
BEGIN
    DECLARE @ApplicationId uniqueidentifier
    SELECT  @ApplicationId = 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

EXEC dbo.aspnet_Applications_CreateApplication @ApplicationName, @ApplicationId OUTPUT

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

IF (EXISTS(SELECT RoleId FROM dbo.aspnet_Roles WHERE LoweredRoleName = LOWER(@RoleName) AND ApplicationId = @ApplicationId))
    BEGIN
        SET @ErrorCode = 1
        GOTO Cleanup
    END

INSERT INTO dbo.aspnet_Roles
                (ApplicationId, RoleName, LoweredRoleName)
         VALUES (@ApplicationId, @RoleName, LOWER(@RoleName))

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_Roles_DeleteRole')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_Roles_DeleteRole
GO

CREATE PROCEDURE dbo.aspnet_Roles_DeleteRole
    @ApplicationName            nvarchar(256),
    @RoleName                   nvarchar(256),
    @DeleteOnlyIfRoleIsEmpty    bit
AS
BEGIN
    DECLARE @ApplicationId uniqueidentifier
    SELECT  @ApplicationId = NULL
    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
    IF (@ApplicationId IS NULL)
        RETURN(1)

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

DECLARE @RoleId   uniqueidentifier
    SELECT  @RoleId = NULL
    SELECT  @RoleId = RoleId FROM dbo.aspnet_Roles WHERE LoweredRoleName = LOWER(@RoleName) AND ApplicationId = @ApplicationId

IF (@RoleId IS NULL)
    BEGIN
        SELECT @ErrorCode = 1
        GOTO Cleanup
    END
    IF (@DeleteOnlyIfRoleIsEmpty <> 0)
    BEGIN
        IF (EXISTS (SELECT RoleId FROM dbo.aspnet_UsersInRoles  WHERE @RoleId = RoleId))
        BEGIN
            SELECT @ErrorCode = 2
            GOTO Cleanup
        END
    END

DELETE FROM dbo.aspnet_UsersInRoles  WHERE @RoleId = RoleId

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

DELETE FROM dbo.aspnet_Roles WHERE @RoleId = RoleId  AND ApplicationId = @ApplicationId

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_Roles_RoleExists')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_Roles_RoleExists
GO

CREATE PROCEDURE dbo.aspnet_Roles_RoleExists
    @ApplicationName  nvarchar(256),
    @RoleName         nvarchar(256)
AS
BEGIN
    DECLARE @ApplicationId uniqueidentifier
    SELECT  @ApplicationId = NULL
    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
    IF (@ApplicationId IS NULL)
        RETURN(0)
    IF (EXISTS (SELECT RoleName FROM dbo.aspnet_Roles WHERE LOWER(@RoleName) = LoweredRoleName AND ApplicationId = @ApplicationId ))
        RETURN(1)
    ELSE
        RETURN(0)
END
GO

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

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_UsersInRoles_AddUsersToRoles')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_UsersInRoles_AddUsersToRoles
GO
IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_UsersInRoles_RemoveUsersFromRoles')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_UsersInRoles_RemoveUsersFromRoles
GO

DECLARE @ver            int
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

IF (@ver > 7)
SELECT @SqlToExec = N'
CREATE PROCEDURE dbo.aspnet_UsersInRoles_AddUsersToRoles
	@ApplicationName  nvarchar(256),
	@UserNames		  nvarchar(4000),
	@RoleNames		  nvarchar(4000),
	@CurrentTimeUtc   datetime
AS
BEGIN
	DECLARE @AppId uniqueidentifier
	SELECT  @AppId = NULL
	SELECT  @AppId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
	IF (@AppId IS NULL)
		RETURN(2)
	DECLARE @TranStarted   bit
	SET @TranStarted = 0

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

DECLARE @tbNames	table(Name nvarchar(256) NOT NULL PRIMARY KEY)
	DECLARE @tbRoles	table(RoleId uniqueidentifier NOT NULL PRIMARY KEY)
	DECLARE @tbUsers	table(UserId uniqueidentifier NOT NULL PRIMARY KEY)
	DECLARE @Num		int
	DECLARE @Pos		int
	DECLARE @NextPos	int
	DECLARE @Name		nvarchar(256)

SET @Num = 0
	SET @Pos = 1
	WHILE(@Pos <= LEN(@RoleNames))
	BEGIN
		SELECT @NextPos = CHARINDEX(N'','', @RoleNames,  @Pos)
		IF (@NextPos = 0 OR @NextPos IS NULL)
			SELECT @NextPos = LEN(@RoleNames) + 1
		SELECT @Name = RTRIM(LTRIM(SUBSTRING(@RoleNames, @Pos, @NextPos - @Pos)))
		SELECT @Pos = @NextPos+1

INSERT INTO @tbNames VALUES (@Name)
		SET @Num = @Num + 1
	END

INSERT INTO @tbRoles
	  SELECT RoleId
	  FROM   dbo.aspnet_Roles ar, @tbNames t
	  WHERE  LOWER(t.Name) = ar.LoweredRoleName AND ar.ApplicationId = @AppId

IF (@@ROWCOUNT <> @Num)
	BEGIN
		SELECT TOP 1 Name
		FROM   @tbNames
		WHERE  LOWER(Name) NOT IN (SELECT ar.LoweredRoleName FROM dbo.aspnet_Roles ar,  @tbRoles r WHERE r.RoleId = ar.RoleId)
		IF( @TranStarted = 1 )
			ROLLBACK TRANSACTION
		RETURN(2)
	END

DELETE FROM @tbNames WHERE 1=1
	SET @Num = 0
	SET @Pos = 1

WHILE(@Pos <= LEN(@UserNames))
	BEGIN
		SELECT @NextPos = CHARINDEX(N'','', @UserNames,  @Pos)
		IF (@NextPos = 0 OR @NextPos IS NULL)
			SELECT @NextPos = LEN(@UserNames) + 1
		SELECT @Name = RTRIM(LTRIM(SUBSTRING(@UserNames, @Pos, @NextPos - @Pos)))
		SELECT @Pos = @NextPos+1

INSERT INTO @tbNames VALUES (@Name)
		SET @Num = @Num + 1
	END

INSERT INTO @tbUsers
	  SELECT UserId
	  FROM   dbo.aspnet_Users ar, @tbNames t
	  WHERE  LOWER(t.Name) = ar.LoweredUserName AND ar.ApplicationId = @AppId

IF (@@ROWCOUNT <> @Num)
	BEGIN
		DELETE FROM @tbNames
		WHERE LOWER(Name) IN (SELECT LoweredUserName FROM dbo.aspnet_Users au,  @tbUsers u WHERE au.UserId = u.UserId)

INSERT dbo.aspnet_Users (ApplicationId, UserId, UserName, LoweredUserName, IsAnonymous, LastActivityDate)
		  SELECT @AppId, NEWID(), Name, LOWER(Name), 0, @CurrentTimeUtc
		  FROM   @tbNames

INSERT INTO @tbUsers
		  SELECT  UserId
		  FROM	dbo.aspnet_Users au, @tbNames t
		  WHERE   LOWER(t.Name) = au.LoweredUserName AND au.ApplicationId = @AppId
	END

IF (EXISTS (SELECT * FROM dbo.aspnet_UsersInRoles ur, @tbUsers tu, @tbRoles tr WHERE tu.UserId = ur.UserId AND tr.RoleId = ur.RoleId))
	BEGIN
		SELECT TOP 1 UserName, RoleName
		FROM		 dbo.aspnet_UsersInRoles ur, @tbUsers tu, @tbRoles tr, aspnet_Users u, aspnet_Roles r
		WHERE		u.UserId = tu.UserId AND r.RoleId = tr.RoleId AND tu.UserId = ur.UserId AND tr.RoleId = ur.RoleId

IF( @TranStarted = 1 )
			ROLLBACK TRANSACTION
		RETURN(3)
	END

INSERT INTO dbo.aspnet_UsersInRoles (UserId, RoleId)
	SELECT UserId, RoleId
	FROM @tbUsers, @tbRoles

IF( @TranStarted = 1 )
		COMMIT TRANSACTION
	RETURN(0)
END'
ELSE
SELECT @SqlToExec = N'
CREATE PROCEDURE dbo.aspnet_UsersInRoles_AddUsersToRoles
	@ApplicationName	nvarchar(256),
	@UserNames			nvarchar(4000),
	@RoleNames			nvarchar(4000),
	@CurrentTimeUtc		datetime
AS
BEGIN
	DECLARE @AppId uniqueidentifier
	SELECT  @AppId = NULL
	SELECT  @AppId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
	IF (@AppId IS NULL)
		RETURN(2)

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

DECLARE @RoleId		uniqueidentifier
	DECLARE @UserId		uniqueidentifier
	DECLARE @UserName	nvarchar(256)
	DECLARE @RoleName	nvarchar(256)

DECLARE @CurrentPosU	int
	DECLARE @NextPosU		int
	DECLARE @CurrentPosR	int
	DECLARE @NextPosR		int

SELECT  @CurrentPosU = 1

WHILE(@CurrentPosU <= LEN(@UserNames))
	BEGIN
		SELECT @NextPosU = CHARINDEX(N'','', @UserNames,  @CurrentPosU)
		IF (@NextPosU = 0 OR @NextPosU IS NULL)
			SELECT @NextPosU = LEN(@UserNames) + 1

SELECT @UserName = SUBSTRING(@UserNames, @CurrentPosU, @NextPosU - @CurrentPosU)
		SELECT @CurrentPosU = @NextPosU+1

SELECT @CurrentPosR = 1
		WHILE(@CurrentPosR <= LEN(@RoleNames))
		BEGIN
			SELECT @NextPosR = CHARINDEX(N'','', @RoleNames,  @CurrentPosR)
			IF (@NextPosR = 0 OR @NextPosR IS NULL)
				SELECT @NextPosR = LEN(@RoleNames) + 1
			SELECT @RoleName = SUBSTRING(@RoleNames, @CurrentPosR, @NextPosR - @CurrentPosR)
			SELECT @CurrentPosR = @NextPosR+1
			SELECT @RoleId = NULL
			SELECT @RoleId = RoleId FROM dbo.aspnet_Roles WHERE LoweredRoleName = LOWER(@RoleName) AND ApplicationId = @AppId
			IF (@RoleId IS NULL)
			BEGIN
				SELECT @RoleName
				IF( @TranStarted = 1 )
					ROLLBACK TRANSACTION
				RETURN(2)
			END

SELECT @UserId = NULL
			SELECT @UserId = UserId FROM dbo.aspnet_Users WHERE LoweredUserName = LOWER(@UserName) AND ApplicationId = @AppId
			IF (@UserId IS NULL)
			BEGIN
				EXEC dbo.aspnet_Users_CreateUser @AppId, @UserName, 0, @CurrentTimeUtc, @UserId OUTPUT
			END

IF (EXISTS(SELECT * FROM dbo.aspnet_UsersInRoles WHERE @UserId = UserId AND @RoleId = RoleId))
			BEGIN
				SELECT @UserName, @RoleName
				IF( @TranStarted = 1 )
					ROLLBACK TRANSACTION
				RETURN(3)
			END
			INSERT INTO dbo.aspnet_UsersInRoles (UserId, RoleId) VALUES(@UserId, @RoleId)
		END
	END
	IF( @TranStarted = 1 )
		COMMIT TRANSACTION
	RETURN(0)
END'

EXEC sp_executesql @SqlToExec

IF (@ver > 7)
SELECT @SqlToExec = N'
CREATE PROCEDURE dbo.aspnet_UsersInRoles_RemoveUsersFromRoles
	@ApplicationName  nvarchar(256),
	@UserNames		  nvarchar(4000),
	@RoleNames		  nvarchar(4000)
AS
BEGIN
	DECLARE @AppId uniqueidentifier
	SELECT  @AppId = NULL
	SELECT  @AppId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
	IF (@AppId IS NULL)
		RETURN(2)

DECLARE @TranStarted   bit
	SET @TranStarted = 0

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

DECLARE @tbNames  table(Name nvarchar(256) NOT NULL PRIMARY KEY)
	DECLARE @tbRoles  table(RoleId uniqueidentifier NOT NULL PRIMARY KEY)
	DECLARE @tbUsers  table(UserId uniqueidentifier NOT NULL PRIMARY KEY)
	DECLARE @Num	  int
	DECLARE @Pos	  int
	DECLARE @NextPos  int
	DECLARE @Name	  nvarchar(256)
	DECLARE @CountAll int
	DECLARE @CountU	  int
	DECLARE @CountR	  int

INSERT INTO @tbNames VALUES (@Name)
		SET @Num = @Num + 1
	END

INSERT INTO @tbRoles
	  SELECT RoleId
	  FROM   dbo.aspnet_Roles ar, @tbNames t
	  WHERE  LOWER(t.Name) = ar.LoweredRoleName AND ar.ApplicationId = @AppId
	SELECT @CountR = @@ROWCOUNT

IF (@CountR <> @Num)
	BEGIN
		SELECT TOP 1 N'''', Name
		FROM   @tbNames
		WHERE  LOWER(Name) NOT IN (SELECT ar.LoweredRoleName FROM dbo.aspnet_Roles ar,  @tbRoles r WHERE r.RoleId = ar.RoleId)
		IF( @TranStarted = 1 )
			ROLLBACK TRANSACTION
		RETURN(2)
	END

DELETE FROM @tbNames WHERE 1=1
	SET @Num = 0
	SET @Pos = 1

INSERT INTO @tbNames VALUES (@Name)
		SET @Num = @Num + 1
	END

INSERT INTO @tbUsers
	  SELECT UserId
	  FROM   dbo.aspnet_Users ar, @tbNames t
	  WHERE  LOWER(t.Name) = ar.LoweredUserName AND ar.ApplicationId = @AppId

SELECT @CountU = @@ROWCOUNT
	IF (@CountU <> @Num)
	BEGIN
		SELECT TOP 1 Name, N''''
		FROM   @tbNames
		WHERE  LOWER(Name) NOT IN (SELECT au.LoweredUserName FROM dbo.aspnet_Users au,  @tbUsers u WHERE u.UserId = au.UserId)

IF( @TranStarted = 1 )
			ROLLBACK TRANSACTION
		RETURN(1)
	END

SELECT  @CountAll = COUNT(*)
	FROM	dbo.aspnet_UsersInRoles ur, @tbUsers u, @tbRoles r
	WHERE   ur.UserId = u.UserId AND ur.RoleId = r.RoleId

IF (@CountAll <> @CountU * @CountR)
	BEGIN
		SELECT TOP 1 UserName, RoleName
		FROM		 @tbUsers tu, @tbRoles tr, dbo.aspnet_Users u, dbo.aspnet_Roles r
		WHERE		 u.UserId = tu.UserId AND r.RoleId = tr.RoleId AND
					 tu.UserId NOT IN (SELECT ur.UserId FROM dbo.aspnet_UsersInRoles ur WHERE ur.RoleId = tr.RoleId) AND
					 tr.RoleId NOT IN (SELECT ur.RoleId FROM dbo.aspnet_UsersInRoles ur WHERE ur.UserId = tu.UserId)
		IF( @TranStarted = 1 )
			ROLLBACK TRANSACTION
		RETURN(3)
	END

DELETE FROM dbo.aspnet_UsersInRoles
	WHERE UserId IN (SELECT UserId FROM @tbUsers)
	  AND RoleId IN (SELECT RoleId FROM @tbRoles)
	IF( @TranStarted = 1 )
		COMMIT TRANSACTION
	RETURN(0)
END
'
ELSE
SELECT @SqlToExec = N'
CREATE PROCEDURE dbo.aspnet_UsersInRoles_RemoveUsersFromRoles
	@ApplicationName  nvarchar(256),
	@UserNames		  nvarchar(4000),
	@RoleNames		  nvarchar(4000)
AS
BEGIN
	DECLARE @AppId uniqueidentifier
	SELECT  @AppId = NULL
	SELECT  @AppId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
	IF (@AppId IS NULL)
		RETURN(2)

DECLARE @TranStarted   bit
	SET @TranStarted = 0

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

DECLARE @RoleId		uniqueidentifier
	DECLARE @UserId		uniqueidentifier
	DECLARE @UserName	nvarchar(256)
	DECLARE @RoleName	nvarchar(256)

DECLARE @CurrentPosU	int
	DECLARE @NextPosU		int
	DECLARE @CurrentPosR	int
	DECLARE @NextPosR		int

SELECT  @CurrentPosU = 1

WHILE(@CurrentPosU <= LEN(@UserNames))
	BEGIN
		SELECT @NextPosU = CHARINDEX(N'','', @UserNames,  @CurrentPosU)
		IF (@NextPosU = 0  OR @NextPosU IS NULL)
			SELECT @NextPosU = LEN(@UserNames)+1
		SELECT @UserName = SUBSTRING(@UserNames, @CurrentPosU, @NextPosU - @CurrentPosU)
		SELECT @CurrentPosU = @NextPosU+1

SELECT @RoleId = NULL
			SELECT @RoleId = RoleId FROM dbo.aspnet_Roles WHERE LoweredRoleName = LOWER(@RoleName) AND ApplicationId = @AppId
			IF (@RoleId IS NULL)
			BEGIN
				SELECT N'''', @RoleName
				IF( @TranStarted = 1 )
					ROLLBACK TRANSACTION
				RETURN(2)
			END

SELECT @UserId = NULL
			SELECT @UserId = UserId FROM dbo.aspnet_Users WHERE LoweredUserName = LOWER(@UserName) AND ApplicationId = @AppId
			IF (@UserId IS NULL)
			BEGIN
				SELECT @UserName, N''''
				IF( @TranStarted = 1 )
					ROLLBACK TRANSACTION
				RETURN(1)
			END

IF (NOT(EXISTS(SELECT * FROM dbo.aspnet_UsersInRoles WHERE @UserId = UserId AND @RoleId = RoleId)))
			BEGIN
				SELECT @UserName, @RoleName
				IF( @TranStarted = 1 )
					ROLLBACK TRANSACTION
				RETURN(3)
			END
			DELETE FROM dbo.aspnet_UsersInRoles WHERE (UserId = @UserId AND RoleId = @RoleId)
		END
	END
	IF( @TranStarted = 1 )
		COMMIT TRANSACTION
	RETURN(0)
END
'
EXEC sp_executesql @SqlToExec
GO
/*************************************************************/
/*************************************************************/

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_UsersInRoles_GetUsersInRoles')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_UsersInRoles_GetUsersInRoles
GO

CREATE PROCEDURE dbo.aspnet_UsersInRoles_GetUsersInRoles
    @ApplicationName  nvarchar(256),
    @RoleName         nvarchar(256)
AS
BEGIN
    DECLARE @ApplicationId uniqueidentifier
    SELECT  @ApplicationId = NULL
    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
    IF (@ApplicationId IS NULL)
        RETURN(1)
     DECLARE @RoleId uniqueidentifier
     SELECT  @RoleId = NULL

SELECT  @RoleId = RoleId
     FROM    dbo.aspnet_Roles
     WHERE   LOWER(@RoleName) = LoweredRoleName AND ApplicationId = @ApplicationId

IF (@RoleId IS NULL)
         RETURN(1)

SELECT u.UserName
    FROM   dbo.aspnet_Users u, dbo.aspnet_UsersInRoles ur
    WHERE  u.UserId = ur.UserId AND @RoleId = ur.RoleId AND u.ApplicationId = @ApplicationId
    ORDER BY u.UserName
    RETURN(0)
END
GO

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

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_UsersInRoles_FindUsersInRole')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_UsersInRoles_FindUsersInRole
GO

CREATE PROCEDURE dbo.aspnet_UsersInRoles_FindUsersInRole
    @ApplicationName  nvarchar(256),
    @RoleName         nvarchar(256),
    @UserNameToMatch  nvarchar(256)
AS
BEGIN
    DECLARE @ApplicationId uniqueidentifier
    SELECT  @ApplicationId = NULL
    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
    IF (@ApplicationId IS NULL)
        RETURN(1)
     DECLARE @RoleId uniqueidentifier
     SELECT  @RoleId = NULL

SELECT  @RoleId = RoleId
     FROM    dbo.aspnet_Roles
     WHERE   LOWER(@RoleName) = LoweredRoleName AND ApplicationId = @ApplicationId

IF (@RoleId IS NULL)
         RETURN(1)

SELECT u.UserName
    FROM   dbo.aspnet_Users u, dbo.aspnet_UsersInRoles ur
    WHERE  u.UserId = ur.UserId AND @RoleId = ur.RoleId AND u.ApplicationId = @ApplicationId AND LoweredUserName LIKE LOWER(@UserNameToMatch)
    ORDER BY u.UserName
    RETURN(0)
END
GO

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

IF (EXISTS (SELECT name
              FROM sysobjects
             WHERE (name = N'aspnet_Roles_GetAllRoles')
               AND (type = 'P')))
DROP PROCEDURE dbo.aspnet_Roles_GetAllRoles
GO

CREATE PROCEDURE dbo.aspnet_Roles_GetAllRoles (
    @ApplicationName           nvarchar(256))
AS
BEGIN
    DECLARE @ApplicationId uniqueidentifier
    SELECT  @ApplicationId = NULL
    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
    IF (@ApplicationId IS NULL)
        RETURN
    SELECT RoleName
    FROM   dbo.aspnet_Roles WHERE ApplicationId = @ApplicationId
    ORDER BY RoleName
END
GO

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

IF (NOT EXISTS (SELECT name
                FROM sysobjects
                WHERE (name = N'vw_aspnet_Roles')
                  AND (type = 'V')))
BEGIN
  PRINT 'Creating the vw_aspnet_Roles view...'
  EXEC(N'
  CREATE VIEW [dbo].[vw_aspnet_Roles]
  AS SELECT [dbo].[aspnet_Roles].[ApplicationId], [dbo].[aspnet_Roles].[RoleId], [dbo].[aspnet_Roles].[RoleName], [dbo].[aspnet_Roles].[LoweredRoleName], [dbo].[aspnet_Roles].[Description]
  FROM [dbo].[aspnet_Roles]
  ')
END
GO

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

IF (NOT EXISTS (SELECT name
                FROM sysobjects
                WHERE (name = N'vw_aspnet_UsersInRoles')
                  AND (type = 'V')))
BEGIN
  PRINT 'Creating the vw_aspnet_UsersInRoles view...'
  EXEC(N'
  CREATE VIEW [dbo].[vw_aspnet_UsersInRoles]
  AS SELECT [dbo].[aspnet_UsersInRoles].[UserId], [dbo].[aspnet_UsersInRoles].[RoleId]
  FROM [dbo].[aspnet_UsersInRoles]
  ')
END
GO

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

--
--Create Role Manager 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'Role Manager', N'1', 1, 1
GO

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

--
--Create Role Manager roles
--

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

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

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

EXEC sp_addrolemember N'aspnet_Roles_BasicAccess', N'aspnet_Roles_FullAccess'
EXEC sp_addrolemember N'aspnet_Roles_ReportingAccess', N'aspnet_Roles_FullAccess'
GO

--
--Stored Procedure rights for BasicAccess
--
GRANT EXECUTE ON dbo.aspnet_UsersInRoles_IsUserInRole TO aspnet_Roles_BasicAccess
GRANT EXECUTE ON dbo.aspnet_UsersInRoles_GetRolesForUser TO aspnet_Roles_BasicAccess
GRANT EXECUTE ON dbo.aspnet_CheckSchemaVersion TO aspnet_Roles_BasicAccess
GRANT EXECUTE ON dbo.aspnet_RegisterSchemaVersion TO aspnet_Roles_BasicAccess
GRANT EXECUTE ON dbo.aspnet_UnRegisterSchemaVersion TO aspnet_Roles_BasicAccess

--
--Stored Procedure rights for ReportingAccess
--
GRANT EXECUTE ON dbo.aspnet_UsersInRoles_IsUserInRole TO aspnet_Roles_ReportingAccess
GRANT EXECUTE ON dbo.aspnet_UsersInRoles_GetRolesForUser TO aspnet_Roles_ReportingAccess
GRANT EXECUTE ON dbo.aspnet_Roles_RoleExists TO aspnet_Roles_ReportingAccess
GRANT EXECUTE ON dbo.aspnet_UsersInRoles_GetUsersInRoles TO aspnet_Roles_ReportingAccess
GRANT EXECUTE ON dbo.aspnet_UsersInRoles_FindUsersInRole TO aspnet_Roles_ReportingAccess
GRANT EXECUTE ON dbo.aspnet_Roles_GetAllRoles TO aspnet_Roles_ReportingAccess
GRANT EXECUTE ON dbo.aspnet_CheckSchemaVersion TO aspnet_Roles_ReportingAccess
GRANT EXECUTE ON dbo.aspnet_RegisterSchemaVersion TO aspnet_Roles_ReportingAccess
GRANT EXECUTE ON dbo.aspnet_UnRegisterSchemaVersion TO aspnet_Roles_ReportingAccess

--
--Additional stored procedure rights for FullAccess
--

GRANT EXECUTE ON dbo.aspnet_Roles_CreateRole TO aspnet_Roles_FullAccess
GRANT EXECUTE ON dbo.aspnet_Roles_DeleteRole TO aspnet_Roles_FullAccess
GRANT EXECUTE ON dbo.aspnet_UsersInRoles_AddUsersToRoles TO aspnet_Roles_FullAccess
GRANT EXECUTE ON dbo.aspnet_UsersInRoles_RemoveUsersFromRoles TO aspnet_Roles_FullAccess

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

GRANT SELECT ON dbo.vw_aspnet_Roles TO aspnet_Roles_ReportingAccess
GRANT SELECT ON dbo.vw_aspnet_UsersInRoles TO aspnet_Roles_ReportingAccess

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

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