Monday, June 01, 2009

How to create a SQL Server database by command line

In previous post, I show you how to attach a SQL Server database by command line, and here I want to show you how to create a SQL Server database by command line.

C:\>sqlcmd -S .\SQLEXPRESS -E
1> use master
2> go
Changed database context to 'master'.
1> create database teamcity collate Latin1_General_CI_AI_KS
2> go

No comments: