Re: Tools with/for Express

Enterprise Manager does not work with SQL Server 2005. Basically, Query
Analyzer is pretty dumb and just passes on what you type, so it still works.
But Enterprise Manager tries to write it's own code and it doesn't use SQL
Server 2005 syntax when it's different or know how to display the new data
types, so it is blocked. If you want features similar to Enterprise Manager,
use Management Studio such as
http://www.microsoft.com/downloads/details.aspx?familyid=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en
--
Rick Byham
MCDBA, MCSE, MCSA
Documentation Manager,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.

"Tom Ellison" <tellison@xxxxxxxxxxx> wrote in message
news:u1Iz5$$MGHA.3832@xxxxxxxxxxxxxxxxxxxxxxx
Dear Andrew:

I'm off to a pretty good start with this. I had to start with SQL Server
Service Manager. This showed me the new instance, which had been named
SQLEXPRESS.

I then attempted to use Query Analyzer. It didn't find the new instance,
but when I manually chose the named instance above, and put in the user
and password, it did open. I can see the appropriate databases inside.

No such luck with Enterprise Manager. Again, I had to manually give it
the name, as it didn't detect the new instance. But this time, it doesn't
find the instance.

Now, due to your help, I'm off and running. I usually use EM a bit to do
my work, but there's nothing here I don't know how to do just using QA.
If you have any suggestions what may be up with EM, it would be helpful.
But your eariler response has been most helpful in getting me started, and
I'm very grateful. I tried harder to get it started because your response
told me I was on the right track, and you were absolutely correct. So, it
nose to the grindwheel now, but I'll be back to see if you have any
additional helpful suggestion.

After all, QA has been where I have "lived" the past 5 years. Assuming
there's no limits to what it can do with SQL Express, there should be no
problems.

Thanks, very much!

Tom Ellison


"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:u7nfyG$MGHA.3100@xxxxxxxxxxxxxxxxxxxxxxx
QA can still access 2005 and should be fine for running scripts. There
will be a management tool for express released shortly that will allow
you to manage things with the gui. There is a beta now available on the
web site.

--
Andrew J. Kelly SQL MVP


"Tom Ellison" <tellison@xxxxxxxxxxx> wrote in message
news:OL5OGR%23MGHA.720@xxxxxxxxxxxxxxxxxxxxxxx
I've been using SQL Server 2000 and MSDE intensively ever since it was
introduced, and 7.0 before that. I have a specific requirement that
will be served by Express 2005.

Initially I only need to be able to create a table using a script, copy
data into it with an append query from other sources, manage indexes for
it, and run performance tests. Would my existing Query Analyzer for
2000 do this? Is there a new Developer Edition that would be better, and
would it be absolutely required?

I'm researching this through the MS web site, but the need is sudden and
I'm very pressed for time. You never learn about a client's needs till
the last second, and they never view the problem in terms of the
resources I'll need to do it.

Thanks very much for your kind responses, helping get me on track
quickly to a solution. I really need to be working later today if
possible, and don't have time to wait even for overnight shipment on
this. I know I can download Express very quickly. I'm mad at myself
that I don't now have MSDN Universal. I promise I will have it again
soon.

That's what I get for trying to be responsive to my client's needs.

So, a thousand thanks and more!

Tom Ellison








.

Relevant Pages

  • Immer noch Probleme mit dem Debugger
    ... Client (Query Analyzer) und SQL Server nicht auf der gleichen Maschine ... Gezielt gesetzte Haltepunkte waren dem Debugger ...
    (microsoft.public.de.sqlserver)
  • Re: SQL 2005 Question
    ... I guess that the easiest way to explain it is that Enterprise Mangler ... included what amounted to some user/client interfaces (e.g., Query Designer) ... Dejan Sarka, SQL Server MVP ... In 2000 enterprise manager, if I wanted ...
    (microsoft.public.sqlserver.tools)
  • Linked Server Problem
    ... I have a view to a table in a linked server (an Access mdb ... file) that works fine in Enterprise Manager and Query ... Analyzer, but when the view is executed in the Access adp ...
    (microsoft.public.access.adp.sqlserver)
  • Re: long SQL lines for osql
    ... It works great in Query ... Analyzer, but when run through osql it takes errors on lines that are ... One thing to keep in mind, is by default OSQL runs with QUOTED_IDENTIFIER ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • SQL Server 2005 Express
    ... I've installed VS.NET 2005 Beta along with SQL Server 2005 Express Beta on ... I'm interested in connecting to SQL Server via query ... analyzer or a similar tool. ...
    (microsoft.public.sqlserver.server)