Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    12

    Unanswered: Creating a new database

    I created a database using the following command :

    create database krish on (Name='krish', filename='C:\Program Files\Microsoft SQL Server\MSSQL\data\krish.mdf', size=25, maxsize=50,filegrowth=5%)

    This actually created the database. Now, I wanted to view this database info being stored inside the SQL Server system tables. I looked at "sysdatabases" table and found an entry as expected for "krish" but I could not trace where the info corresponding to the size of the database was stored ie.25MB . (I looked ad "sysdevices" but couldn't find any entry for the newly created database).

    In which table is it stored ?

    Any help is appreciated.

  2. #2
    Join Date
    Mar 2004
    Posts
    45
    select size
    from krish.dbo.sysfiles
    Hans.

  3. #3
    Join Date
    Mar 2004
    Posts
    12
    Thanks Hans. That worked

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •