Hi guys,

i need to create a database..

i don't how to script it create the database dynamically..

if anyone could help it will be greatly appreciated..

by the way i am using sql server 2005...

i have already tried the following script..

it doesn't work though....

USE master

GO

CREATE DATABASE Student

ON

( NAME = Student_dat,

FILENAME = 'c:\program files\microsoft sql server\mssql\data\Studentdat.mdf',

SIZE = 20MB,

MAXSIZE = 70MB,

FILEGROWTH = 5MB )

LOG ON

( NAME = 'Student_log',

FILENAME = 'c:\program files\microsoft sql server\mssql\data\Student.ldf',

SIZE = 10MB,

MAXSIZE = 40MB,

FILEGROWTH = 5MB )

GO

cheers.....