Post reply

New folder creation

  • October 25, 2007 at 4:52 am

    #119232

    Hi,

    Is it possbile to create a new folder within SQL Server Management Studio. We have two offices for our company so i would like to create two new folders for each and have associated databases underneath each one.

    e.g.

    Dublin

    Database 1

    Database 2

    Etc.

    London

    Database 1

    Database 2

    Etc.

    Thanks,

    Sully

  • October 25, 2007 at 4:57 am

    #745308

    Unfortunately Management Studio does not support organizing databases in the Object Explorer.

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • October 25, 2007 at 5:00 am

    #745309

    Thanks Andras.

    Is there another way i can do this or is just not possible

    Thanks

  • October 25, 2007 at 5:06 am

    #745314

    And fortunately it does support organizing servers into groups in means of registered server explorer🙂

    --Ramesh

  • October 25, 2007 at 5:08 am

    #745315

    If you can separate the databases into different instances, you can have an instance for Dublin, one for London.

    Management Studio allows organizing servers into groups, You need to register your servers, and then organize them in the Registered Server Group window.

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • October 25, 2007 at 5:13 am

    #745317

    I have only 1 SQL Server so does that mean i have only 1 instance?

    Therefore is it not possible to do what i am trying to do using instances?

  • October 25, 2007 at 8:18 am

    #745391

    Can someone tell me can i create a new instance with one copy of SQL2005 on one server?

    If so, how do i do this?

    Thanks

  • October 26, 2007 at 5:21 am

    #745643

    install a named instance of Sql.

  • October 26, 2007 at 5:24 am

    #745645

    you can install the sql once more , give a different instance name than your existing instance.

    While installing it will ask whether you want to upgrade existing instance or add a new one. Give a name and cotinue installing.

    "Keep Trying"

  • October 26, 2007 at 5:26 am

    #745646

    Concerning licensing, from the SQL Servfer licensing FAQ http://www.microsoft.com/sql/howtobuy/faq.mspx:

    You can run multiple instances of SQL Server 2005 on a single computer. Multiple instances are used by organizations that have several applications running on a server but want them to run in isolation so that any problem in one instance will not affect the other instances. In SQL Server 2005, you can now run multiple instances with the Workgroup, Standard, and Enterprise editions when they are licensed server/CAL or on a per-processor basis.

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

Viewing 10 posts - 1 through 9 (of 9 total)

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