Create Database

DTS Designer

DTS Designer Help

Create Database

Use this dialog box to define a new database for a data source connection. You can define a new database only when connecting to an instance of Microsoft® SQL Server™ through the Microsoft OLE DB Provider for SQL Server or through the Microsoft OLE DB Provider for ODBC. The database files will be put into the same location as your master database files. If you are unable to create a new database, make sure your login has the appropriate permissions.

This dialog box is provided for simplicity and convenience, but does not include all available options for creating databases. To have access to all options, click New Database in SQL Server Enterprise Manager.

Make sure to follow SQL Server naming conventions for the database, and set the data file size and log file size for the new database appropriately. For more information, see Naming Conventions for Instances of SQL Server 2000.

See Also

Creating a Database