19 lines
637 B
Transact-SQL
19 lines
637 B
Transact-SQL
USE [master]
|
|
GO
|
|
|
|
CREATE DATABASE esuite
|
|
CONTAINMENT = PARTIAL
|
|
ON PRIMARY
|
|
( NAME = N'esuite', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\esuite_Primary.mdf' , SIZE = 10MB , MAXSIZE = UNLIMITED, FILEGROWTH = 10MB )
|
|
LOG ON
|
|
( NAME = N'esuite_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\esuite_Primary.ldf' , SIZE = 1024KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB)
|
|
GO
|
|
|
|
ALTER DATABASE esuite SET RECOVERY SIMPLE
|
|
|
|
use esuite;
|
|
go
|
|
|
|
CREATE USER [ApplicationUser] WITH PASSWORD=N'Plz change me on live, thank you', DEFAULT_SCHEMA=[dbo]
|
|
GO
|