Post reply

how create new database using SSMS in SQL Server 2005

  • December 7, 2008 at 10:29 pm

    #383533

    can any one help with creating a new database using SSMS in SQL Server 2005 ,specify installtion path and specify maximum size.

  • December 8, 2008 at 12:48 am

    #909018

    Just right click Database and select 'New Database...'

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • December 8, 2008 at 1:25 am

    #909021

    1. Go to Object explorer

    2. Right click on Database icon under right server.

    3. A window ll appear, where u can specify new database name. datafile and log flle name and path and other database properties.

    4. Click ok.

  • December 8, 2008 at 1:27 am

    #909022

    OOhhh, forgotten to write, u can also run the CRETAE database script from a query window, specifying all the parameters.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply