By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,767 Members | 1,302 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,767 IT Pros & Developers. It's quick & easy.

Database not Shown

P: n/a
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

Jul 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
I got the answer. I closed the SQl sErver n then run it again n then it
show me the newly created database.

Jul 23 '05 #2

P: n/a
Hi

Sometime you need to refresh either by selecting the menu (right click) and
choosing refresh or pressing F5 when on the appropriate node of the tree.

John

<ar********@hotmail.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...
I got the answer. I closed the SQl sErver n then run it again n then it
show me the newly created database.

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.