Opret db og bruger via kommandolinie

CREATE DATABASE mindatabase

:-)

eksempel fra docs

CREATE DATABASE Sales
ON
( NAME = Sales_dat,
  FILENAME = 'c:\program files\microsoft sql server\mssql\data\saledat.mdf',
  SIZE = 10,
  MAXSIZE = 50,
  FILEGROWTH = 5 )
LOG ON
( NAME = 'Sales_log',
  FILENAME = 'c:\program files\microsoft sql server\mssql\data\salelog.ldf',
  SIZE = 5MB,
  MAXSIZE = 25MB,
  FILEGROWTH = 5MB )
GO

for oprettelse af logins sp_grantlogin for windows security og sp_addlogin
for SQLServer security

eksempler

EXEC sp_grantlogin 'Corporate\BobJ'

EXEC sp_addlogin 'Albert', 'B1r12-36', 'corporate'

for at give adgang til DB sp_grantdbaccess

eksempel

EXEC sp_grantdbaccess 'Corporate\GeorgeW', 'GeorgeW'

OK ?