Articles
SQL Query - Creating the Database (Sub-Article) (#1 of 2)
Creating the Database
The script below can be run to create the WEBPREFSDB shell database.
USE [master]
GO
/****** Object: Database [WEBPREFSDB] Script Date: 4/1/2019 10:40:02 AM ******/
CREATE DATABASE [WEBPREFSDB]
CONTAINMEN...
SQL Query - Adding Tables (Sub-Article) (#2 of 2)
Adding Tables
The script below can be run to add tables to the WEBPREFSDB database.
USE [WEBPREFSDB]
GO
/****** Object: Table [dbo].[Entity] Script Date: 4/1/2019 10:41:11 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO...
SQL Query - Creating the Database (Sub-Article) (#1 of 5)
Creating the Database
The script below can be run to create the ASPNETDB shell database.
Please note at the top of the script there are two directories specified. These directories will only work with SQL Express 2016 default installation...
SQL Query - Adding Tables (Sub-Article) (#2 of 5)
Adding Tables
The script below can be ran to add tables to the ASPNETDB database.
USE [ASPNETDB]
GO
/****** Object: Table [dbo].[aspnet_Applications] Script Date: 4/1/2019 10:27:56 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDEN...
SQL Query - Adding Views (Sub-Article) (#3 of 5)
Adding Views
The script below can be run to add views to the ASPNETDB database.
USE [ASPNETDB]
GO
/****** Object: View [dbo].[vw_aspnet_Applications] Script Date: 4/1/2019 10:28:40 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDEN...
SQL Query - Adding Stored Procedures (Sub-Article) (#4 of 5)
Adding Stored Procedures
This script can be run to add stored procedures to the ASPNETDB database....
SQL Query - Adding Roles Functions and Schemas (Sub-Article) (#5 of 5)
Adding Roles Functions and Schemas
The script below can be ran to add roles, functions, and schemas to the ASPNETDB database.
USE [ASPNETDB]
GO
/****** Object: DatabaseRole [aspnet_Membership_BasicAccess] Script Date: 4/1/2019 10:3...
SQL Query - Manually Create ASPNETDB and WEBPREFSDB
This document details how to create the ASPNETDB and WEBPREFSDB with just SQL queries. (Each item links out to a separate article)
ALL QUERIES MUST BE RUN IN THE ORDER SPECIFIED
ASPNETDB Creation
The ASPNETDB creation is broken d...