Creating an empty database -- sql server new users

sql server new users : Creating an empty database

Nathan Sokalski
6/22/2005 4:28:00 PM

I want to create an empty SQL Server database with nothing in it so that I
can add tablesand other stuff to it using sql code. How do I do this?
--
Nathan Sokalski
njsokalski@hotmail.com
http://www.nathansokalski.com/

Armando Prato
6/22/2005 4:35:19 PM

via query analyzer to create a bare bones db with defaults:

create database mydatabase

Look up CREATE DATABASE in BOL for a full, rich set of options

[quoted text, click to view]

Raymond D'Anjou
6/22/2005 4:44:01 PM

Open Enterprise Manager
Expand Microsoft SQL Servers
Expand SQL Server Group
Expand the group where you wish to ceate the database
Right-click Database
Choose "New Database..."
Fill in the blanks and click OK

[quoted text, click to view]

Jens Süßmeyer
6/23/2005 12:00:00 AM

@op: YOu should consider the fact that objects from the model db are copied
when creating a new database. THat builds the basis forall new database. SO
if you wantto make sure thataspecial object should reside in every new
database, just create it there and all followingnew dbs will contain this.

--
HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---
"Armando Prato" <aprato@REMOVEMEkronos.com> schrieb im Newsbeitrag
news:e8rGrn2dFHA.2420@TK2MSFTNGP12.phx.gbl...
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

home · blog · groups

Questions? Comments? Contact the dn