Re: SSMS problem

I've never installed from DC so I don't know which disc it is on. But if you start setup, you will find that SSMS is installed in "Client Components" (or some similar name).

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"GeekBoy" <nobody@xxxxxxxxxxx> wrote in message news:46b6d9e7$0$20582$4c368faf@xxxxxxxxxxxxxxxxx

"Tibor Karaszi" <tibor_please.no.email_karaszi@xxxxxxxxxxxxxxxxxx> wrote in message news:A946D969-7DDD-4C1B-8005-911F49D8437E@xxxxxxxxxxxxxxxx
I found out that the reason SSMS is not showing up is because Visual Studio 2005 is installed and you have to use its software to deal with the database.

No, that is not the case. I have both VS and SSMS on a number of machines, and I don't use VS to manage my databases. I'd check of you have the exe file for SSMS installed. The name of the file is SqlWb.exe. And the full path (on my machine) is:
C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe




I searched all of the Program Files folders and cannot find any such file named that.

Is SSMS on disc one or two?
I installed All I could on disc one

Thanks for the reponse

--




Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"GeekBoy" <geek@xxxxxxx> wrote in message news:46b67c6f$0$8913$4c368faf@xxxxxxxxxxxxxxxxx
Doing some reading and.
I found out that the reason SSMS is not showing up is because Visual Studio 2005 is installed and you have to use its software to deal with the database.


However I have run into two problems.
First is modifying the data. I want to insert more data into the tables, but cannot.

The other problem is adding a new user to SQL server for the purpose of having a web site that uses that database.
In 2000 version , one only needed to use Enterprise Manager

How can I do both?

Thanks


"GeekBoy" <geek@xxxxxxx> wrote in message news:46b65e81$0$30655$4c368faf@xxxxxxxxxxxxxxxxx
I finally got my other problems corrected, but a new one has popped up.

SSMS is installed, but does not show up in the START menu in the SQL 2005 group as it is suppose to.

Any other way of executing it?

Thanks





.

Relevant Pages

  • Re: SQL Server Management Studio Cannot Open SQL Express Files
    ... Currently I can work with the DB in SSMS but not in VS. ... I suggest you to open SQL Server Configuration Manager and see how many SQL ... If I create the database in VS2005 using the ... If I create the DB in Management Studio I cannot work with it in VS2005. ...
    (microsoft.public.sqlserver.tools)
  • Re: SSMS problem PS
    ... Tibor Karaszi, SQL Server MVP ... I see no way of doing it and I got a web site that hs been down for 2 days because it no longer has a user account for the database. ... I have both VS and SSMS on a number of machines, and I don't use VS to manage my databases. ...
    (microsoft.public.sqlserver.tools)
  • Re: SSMS problem
    ... I have both VS and SSMS on a number of machines, and I don't use VS to manage my databases. ... I'd check of you have the exe file for SSMS installed. ... I found out that the reason SSMS is not showing up is because Visual Studio 2005 is installed and you have to use its software to deal with the database. ... The other problem is adding a new user to SQL server for the purpose of having a web site that uses that database. ...
    (microsoft.public.sqlserver.tools)
  • Re: ssms not seeing local sql server
    ... On SSMS, when I click the down arrow on the Server Name and click on <Browse ... for more...>, under the Local Servers tab, the Database Engine can not be ... collapsed even though I know there are two local instances running (one ... Please make sure SQL Server is running". ...
    (microsoft.public.sqlserver.tools)
  • Re: Need Help With Express Edition Tools
    ... created using SQL Server 2000 that I'm using in an ASP.NET ... I can open the database just fine and use it in the ... but when I try to attach to it from SSMS ... as the database file is already open by the the user instance. ...
    (microsoft.public.sqlserver.tools)
Loading