Re: SSMS problem


"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: Enterprise Manager Newbie Question
    ... "Remember password" option when running SSMS? ... Tibor Karaszi, SQL Server MVP ... why don't you write a short backup script using the SQLCMD utility ... Senior Database Administrator ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL Server 2000 EM vs. SQL Server 2005 MS
    ... Of course, SSMS will mature over time, for instance based on feedback at http://connect.microsoft.com/sqlserver. ... Tibor Karaszi, SQL Server MVP ... > database properties' selection. ... not work with some functionality in SQL Server. ...
    (microsoft.public.sqlserver.tools)
  • Re: Connect from SQL2005 Mgt Studio to SQL 2000 Analysis server
    ... Run Migration Wizard from SQL Management Studio to migrate your AS2000 ... You will need to re-process your cubes after migrating. ... Connecting to SQL 2000 database server works fine, ...
    (microsoft.public.sqlserver.olap)
  • RE: How can I remove Public access to SQL Express dbs?
    ... To remove the public of a database, we just need to revoke the permission ... Management Studio. ... By default the SQL Server Management Studio is not available in the ... it will remove the public access of the database in question. ...
    (microsoft.public.sqlserver.security)
  • Re: SSMS problem PS
    ... Could you tell me how to get a user accounts back on SQL 2005? ... 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)