SQL Management Studio - Set Default DB

Discussion in 'Databases' started by mapyourhike, May 20, 2009.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. mapyourhike

    mapyourhike

    I'm wondering how I can set SQL Server Managment Studio to only connect to my database when I connect to the DiscountASP SQL Server.

    It would make life simpler than having to scroll through a massive list of dbs to find my own.

    In the connection properties, I have already set the default db however, the entire list of all dbs on the server still shows up.

    Thx for the assistance.
     
    mapyourhike, May 20, 2009
    #1
  2. raymondp

    raymondp

    I'm assuming you are referring to SQL 2005. Unfortunately this is how Microsoft designed the product. There were certain technical difficulties that we encountered to customize a SQL 2005 server so that a user logging in would be redirected to there database. If it was a dedicated SQL 2005 server it wold have been easy but because it is configured as a shared hosting environment it was a little more difficult. Unforutnately for our SQL 2005 shared hosting server this cannot be avoided.
     
    raymondp, May 21, 2009
    #2
  3. Takeshi Eto

    Takeshi Eto DiscountASP.NET Staff

    SQL is generally designed for enterprise companies and being able to see all the sql databases is considered a feature. So Microsoft has not put much effort into figuring out how to not display the databases. I know our team has brought this up with the Microsoft SQL team so hopefully there will be improvements in the product from a shared hosters perspective.
     
    Takeshi Eto, May 21, 2009
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page