softsys.sql

用ｖｂ编的一个软件项目开发系统

USE master
GO
CREATE DATABASE SoftSys
ON
PRIMARY ( NAME = Soft1,
      FILENAME = 'c:\program files\microsoft sql server\mssql\data\SoftData1.mdf',
      SIZE = 100MB,
      MAXSIZE = 200,
      FILEGROWTH = 20),
( NAME = Soft2,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\SoftData2.ndf',
   SIZE = 100MB,
   MAXSIZE = 200,
   FILEGROWTH = 20),
( NAME = Soft3,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\SoftData3.ndf',
   SIZE = 100MB,
   MAXSIZE = 200,
   FILEGROWTH = 20)
LOG ON 
( NAME = SoftLog1,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\SoftLog1.ldf',
   SIZE = 100MB,
   MAXSIZE = 200,
   FILEGROWTH = 20),
( NAME = SoftLog2,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\SoftLog2.ldf',
   SIZE = 100MB,
   MAXSIZE = 200,
   FILEGROWTH = 20)
GO