Database not Shown

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • arfanameer@hotmail.com

    Database not Shown

    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@hotmail.com

    #2
    Re: Database not Shown

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

    Comment

    • John Bell

      #3
      Re: Database not Shown

      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

      <arfanameer@hot mail.com> wrote in message
      news:1104128525 .843334.92980@f 14g2000cwb.goog legroups.com...[color=blue]
      >I got the answer. I closed the SQl sErver n then run it again n then it
      > show me the newly created database.
      >[/color]


      Comment

      Working...