CREATE DATABASE syntax for M$ SQL 7

The_Chancer

Any ideas ?

I know the mySql is CREATE DATABASE [if not exists] db_name

But I don't know the M$ SQL - any clues ?

Cheers,

The_Chancer

Would something like:

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

work do you think ? Yet to try - but time to go home !
Answers on a postcard please (or in the forum I don't mind!)

Cheers

The_Chancer

Using the following:

CREATE DATABASE hotel999
ON 
( NAME = 'Sales_dat',
   FILENAME = 'd:\mssql7\data\hotel999_dat.mdf',
   SIZE = 1,
   FILEGROWTH = 10% )
LOG ON
( NAME = 'Sales_log',
   FILENAME = 'd:\mssql7\data\hotel999_log.ldf',
   SIZE = 1,
   FILEGROWTH = 10% )

creates a database on MS SQL server starting at 1Mb with unrestricted growth (to cap the file add

MAXSIZE= [I]nn[/I]MB

after SIZE

with a file increase of 10% per..

Hope this helps someone else.