Re: SSMS problem



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

--
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: 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: 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)
  • 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: Creating 3.5 databases ?
    ... You can create the database using the Server ... Tables node and right click to add tables.(Or use SSMS.) Then use Data ... It automagically creates the TableAdapter ... I also cannot reference it in code as it tells me it cannot find ...
    (microsoft.public.sqlserver.ce)
  • Re: SSMS problem display database list on remote server
    ... Actually I just noticed that you are using SSMS Express, ... SSMS Express have an Object Explorer Details pane? ... SSMS Express 2008 to access our database on ... the server of our hoster. ...
    (microsoft.public.sqlserver.tools)