I am creating database with script sql file running in command prompt.
The database files are created but database is not shown on SQl Server
.. wat am I missing here?
The databse script is
CREATE DATABASE Budget
ON ( NAME = Budget_data,
FILENAME = 'c:\mssql7\data \Budgetdata.mdf ',
SIZE = 100, MAXSIZE = 500, FILEGROWTH = 25 )
LOG ON ( NAME = 'Budget_log',
FILENAME = 'c:\mssql7\data \budgetlog.ldf' ,
SIZE = 5MB, MAXSIZE = 25MB, FILEGROWTH = 5MB )
GO
The database files are created but database is not shown on SQl Server
.. wat am I missing here?
The databse script is
CREATE DATABASE Budget
ON ( NAME = Budget_data,
FILENAME = 'c:\mssql7\data \Budgetdata.mdf ',
SIZE = 100, MAXSIZE = 500, FILEGROWTH = 25 )
LOG ON ( NAME = 'Budget_log',
FILENAME = 'c:\mssql7\data \budgetlog.ldf' ,
SIZE = 5MB, MAXSIZE = 25MB, FILEGROWTH = 5MB )
GO
Comment