creating data base with microsoft SQL 7.0

[jose]

HI, I am new to sql an just bought a boo.I am trying to create a date base
with a simple table.My problem is that I don't know what procedures should
I follow in order to create using Microsoft SQL server 7.0 .Can someone help
me with this,this will be my very first sql database. Any help will be greatly
apreciated.

thanks

[CLM]

Here's a simple T-SQL script for building a database that you can run in Query
Analyzer or in code. Be careful about accidently building a database on
any drive (such as c that has limited space.

CREATE DATABASE B936_DB
ON
PRIMARY ( NAME = B936_DB_Dat,
FILENAME = 'd:\data\B936_DB.mdf',
SIZE = 1MB,
FILEGROWTH = 10MB)

LOG ON
(NAME = B936_DB_Log,
FILENAME = 'd:\data\B936_DB.ldf',
SIZE = 1MB,
FILEGROWTH = 5MB)
GO

"jose" <joseamarte@netzero.net> wrote:
>
>HI, I am new to sql an just bought a boo.I am trying to create a date base
>with a simple table.My problem is that I don't know what procedures should
>I follow in order to create using Microsoft SQL server 7.0 .Can someone
help
>me with this,this will be my very first sql database. Any help will be greatly
>apreciated.
>
>thanks