Eric Barro
ebarro at verizon.net
Wed Jul 11 10:05:04 CDT 2007
CREATE DATABASE [dbname] ON (NAME = 'dbname_Data', FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL\data\dbname.MDF', SIZE = 21, FILEGROWTH = 10%) LOG ON (NAME = 'dbname_Log', FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL\data\dbname_Log.LDF' , SIZE = 1, FILEGROWTH = 10%) -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Wednesday, July 11, 2007 8:01 AM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Build a database Is there SQL code to programmatically build a database container in SQL Server? If not, is it possible at all, i.e. stored procedure etc, and if so, what would the code for that look like? John W. Colby Colby Consulting www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com