SQL 2005 - I am Missing an Installed Component Help!!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

alvinstraight38@hotmail.com - 17 Mar 2008 15:42 GMT

Hey guys,

This may sound like a dumb question, but I am remoted to a customer's
server, and I need to run some SQL scripts. They do have SQL server
2005 installed.

However, when I browse the program list, I only see SQL configuration
tools. Is there a component that they need to install like Studio
Express, or is there some back door way for me to access Query
Analyzer? I'm used to SQL 2000 which had Enterprise Manager.

Thanks!

Reply to this Message

Tibor Karaszi - 17 Mar 2008 16:46 GMT

The Replacement in 2005 for Enterprise Manager *and* Query Analyzer is called SQL Server Management
Studio (SQLWB.EXE). If that isn't installed, then you can use SQLCMD.EXE (replacement for OSQL.EXE).
If you don't want to use SQLCMD or OSQL, then you need to install either SQL server Management
Studio (SSMS) or download and install SQL Server Management Studio Express. If they have a "proper"
SQL Server (not Express) then they should have the installation media so you can install the
"Proper" version of SSMS.

Signature

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

> Hey guys,
>
[quoted text clipped - 8 lines]
>
> Thanks!

Reply to this Message

Geoff N. Hiten - 17 Mar 2008 18:38 GMT

By chance is this a clustered SQL Server?

Signature

Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

> Hey guys,
>
[quoted text clipped - 8 lines]
>
> Thanks!

Reply to this Message