?
Solved

Run command to open Sql management studio?

Posted on 2008-10-14
10
Medium Priority
?
997 Views
Last Modified: 2012-08-13
Hi all,

Is there a "generic" run command to open Sql management studio?

Thanks,

Zee
0
Comment
Question by:zeeshanbutt
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
10 Comments
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 2000 total points
ID: 22715317
sqlwb
0
 

Author Comment

by:zeeshanbutt
ID: 22715576
BrandonGalderisi,
Thanks. It looks that your run command is correct, since when I run it on my loacl machine it does open SQL Managment Studio.

Actually I need to check on our client's server if they have SQL Server 2005 (including reporting services) is installed or not. There, I dont see Sql Managment studio in start > Programs.
When I run "sqlwb" it gives erorr, that "Windows cannot find sqlwb".

Please see the attached image. As you can see there's only "Surface Area Configration", but where is the "SQL Managment Studio", and "SQL Server Business Intelligence Development Studio"? How to find out without asking the client if the above are installed on the client's server or not?

Please suggest
screenshot.JPG
0
 

Author Comment

by:zeeshanbutt
ID: 22715681
Can someone help please.
Thanks for the prompt help.

Zee
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 22715697
That's because client tools are not installed on that box.  If you install client from the CD it will be there.
0
 

Author Comment

by:zeeshanbutt
ID: 22715710
BrandonGalderisi,

When you say client tools what exactly you mean. Please explain.

Thanks,

Zee
0
 

Author Comment

by:zeeshanbutt
ID: 22715738
BrandonGalderisi,

Also could that be possible that although client tools are installed, and I am maybe not an administrator on that server, and that is why I am unable to see "SQL Managment Studio", and "SQL Server Business Intelligence Development Studio"?  Please comment.

Also when you say client tools what exactly you mean. Please explain.

Thanks for your help.

Zee
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 22715743
SQL Server Management Studio is a client tool used for accessing SQL Server and is not part of the engine itself.  For example, you wouldn't want people logging in to your DB server to run a query, so you install the client tools on a developers machine.  From there, they can attach to the SQL DB Engine running on the other server to run queries and such.
0
 

Author Comment

by:zeeshanbutt
ID: 22715762
Thanks BrandonGalderisi.
Now could that be possible that although client tools are installed, and I am maybe not an administrator on that server, and that is why I am unable to see "SQL Managment Studio", and "SQL Server Business Intelligence Development Studio"?  Please comment.
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 22715763
Being an administrator on the server doesn't necessarily mean you wouldn't see items in the start menu.  That's separate from being an administrator as by default the client tools are installed into the all users profile.  It is most likely that client tools were not installed on that server to discourage people from using it as a location to run queries from.
0
 

Author Comment

by:zeeshanbutt
ID: 22715928
BrandonGalderisi,

Thanks for your valueable information.

Zee
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question