Create Database

  • Thread starter Thread starter Adrian
  • Start date Start date
A

Adrian

When I enter the code below into the cmnd.CommandText string
I get nothing but errors, presumably something else should be
done: What?

Adrian

USE master
GO
CREATE DATABASE Employees
ON
( NAME = Empl_dat,
FILENAME = 'f:',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = 'Sales_log',
FILENAME = 'g:',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )
GO
 
Have you tried just using the Create string as the query string (i.e.
without the "USE master" and "GO" statements). Then when you create your
adaper open up the master database as part of your connection string?
 
GO is not a TSQL command. It only works in Query Analyzer.

Split the commands at the GO keyword and execute each separately.
 
Back
Top