CREATE DATABASE Employees
ON
( NAME = Empl_dat,
FILENAME = 'd:\sample data dir\',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = 'Sales_log',
FILENAME = 'd:\sample log dir\',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )
------------------------------------------------------------
把语句放到Query里或ADOCommand里~~~
ON
( NAME = Empl_dat,
FILENAME = 'd:\sample data dir\',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = 'Sales_log',
FILENAME = 'd:\sample log dir\',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )
------------------------------------------------------------
把语句放到Query里或ADOCommand里~~~
create database mydb
即可,要更详细的请查看SQL SERVER ONLINE
ON
( NAME = adb,
FILENAME = 'c:\mydb\',
SIZE = 1,
MAXSIZE = 50,
FILEGROWTH = 1)
LOG ON
( NAME = 'adb_log',
FILENAME = 'c:\mydb\',
SIZE = 1,
MAXSIZE = 25,
FILEGROWTH = 1 )
方法可以使用第一个老兄写的那段代码,应该就可以了。