find sql server, but when I click on that I get "configuration tools".
I don't see anything that says "enterprise manager" for instance. How
can I find it so I can make a shortcut to it?
ThanksIf you installed SQLServer2k (not the msde edition) you should find the
Managment SnapIn with the name SQL Server Enterprise Manager.msc
somewhere on your computer (YOu insallation computer). Otherwise you
can also define your own MMC with importing Snapins in any MMC console.
HTH; Jens Suessmeyer.|||On 4 Feb 2006 02:18:02 -0800, BLACKDOG157@.LYCOS.COM wrote:
>I installed sql server on my PC, and when I look at the Programs I do
>find sql server, but when I click on that I get "configuration tools".
>I don't see anything that says "enterprise manager" for instance. How
>can I find it so I can make a shortcut to it?
>Thanks
Hi Blackdog157,
In addition to Jens' answer:
- Are the client tools installed oon your workstation?
- If so, are they installed with default settings?
If both questions are answered with "yes", then you should find
Enterprise Manager (as well as Query Analyzer and all other tools) via:
Start / Programs / Microsoft SQL Server / Enterprise Manager
--
Hugo Kornelis, SQL Server MVP|||Hi
To add to the others... you may to look around the Control Panel/Add Remove
programs to see what is there. SQL 2005 has a report feature within this
that will give you more details.
For SQL 2005 executables look for SqlWb.exe on you Hard Drive and
SQLServerManager.msc, you could also try osql and/or sqlcmd (for SQL 2005)
from a command prompt.
John
<BLACKDOG157@.LYCOS.COM> wrote in message
news:1139048282.042362.258000@.z14g2000cwz.googlegr oups.com...
>I installed sql server on my PC, and when I look at the Programs I do
> find sql server, but when I click on that I get "configuration tools".
> I don't see anything that says "enterprise manager" for instance. How
> can I find it so I can make a shortcut to it?
> Thanks|||(BLACKDOG157@.LYCOS.COM) writes:
> I installed sql server on my PC, and when I look at the Programs I do
> find sql server, but when I click on that I get "configuration tools".
> I don't see anything that says "enterprise manager" for instance. How
> can I find it so I can make a shortcut to it?
It sounds as if you installed SQL Server Express 2005. The Express
download does not include any other qurey tool than SQLCMD, which is a
command line tool.
However, a stripped-down version of SQL Server Managerment Studio is
available as beta from
http://www.microsoft.com/downloads/...playLang=en&Src
CategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3d82afbd5 9
-57a4-455e-a2d6-1d4c98d40f6e%26DisplayLang%3den
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
