locked
SQL Server Management Studio Express RRS feed

  • Question

  • Hello Everyone,

    I'm new to SQL Server and was wondering with Management Studio Express is it possible to connect to SQL Server 2000. I got a hosting acct and they are using SQL Server 2000. If this wont work can somebosy suggest a free tool similar which can graphically connect to SQL 2000 and create tables or procedures and so on...

    Thanks,

    Harsimrat

    Thursday, May 25, 2006 3:42 PM

Answers

  • Hi Harsimrat,

    Management Studio Express can connect to SQL 2000. It's a totally different question whether your hosting site will actually let you connect to their server using management studio and perform the database options you want to. Many hosters prevent this type of connection.

    You should contact your hoster to determine if they will allow this and to get their recomendations about how to connect to an manage your hosted database.

    Regards,

    Mike Wachal
    SQL Express team

    ----
    Please mark your thread as Answered when you get your solution.

    Thursday, May 25, 2006 7:12 PM

All replies

  • Hi Harsimrat,

    Management Studio Express can connect to SQL 2000. It's a totally different question whether your hosting site will actually let you connect to their server using management studio and perform the database options you want to. Many hosters prevent this type of connection.

    You should contact your hoster to determine if they will allow this and to get their recomendations about how to connect to an manage your hosted database.

    Regards,

    Mike Wachal
    SQL Express team

    ----
    Please mark your thread as Answered when you get your solution.

    Thursday, May 25, 2006 7:12 PM
  • Awesome,

    Thanks

    Harsimrat

    Thursday, May 25, 2006 7:57 PM