Groups | Blog | Home
all groups > sql server (alternate) > december 2004 >

sql server (alternate) : Database not Shown


arfanameer NO[at]SPAM hotmail.com
12/26/2004 10:10:58 PM
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
arfanameer NO[at]SPAM hotmail.com
12/26/2004 10:22:05 PM
I got the answer. I closed the SQl sErver n then run it again n then it
show me the newly created database.
John Bell
12/27/2004 12:05:27 PM
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

[quoted text, click to view]

AddThis Social Bookmark Button