Skip to content

Instantly share code, notes, and snippets.

This file has been truncated, but you can view the full file.
USE [master]
GO
/****** Object: Database [NW] Script Date: 12/10/2025 23:09:42 ******/
CREATE DATABASE [NW]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'Northwind', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\NW.MDF' , SIZE = 5184KB , MAXSIZE = UNLIMITED, FILEGROWTH = 80KB )
LOG ON
( NAME = N'Northwind_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\NW_log.ldf' , SIZE = 4672KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
WITH CATALOG_COLLATION = DATABASE_DEFAULT, LEDGER = OFF