Re: Tools with/for Express

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

  • Re: Cannot edit table data using Enterprise Manager
    ... The point of using Query Analyzer is that you write the ... they could have had the SQL written and been done with it! ... change or insert some words to data string using Replace function is ... Manager wasn't designed to be a data entry tool. ...
    (microsoft.public.sqlserver.tools)
  • Any way to get the equiv. of Q Anaylzer row(s) affected in SQL?
    ... Is there some "global" variable that contains the affected rows from a SQL ... where is Query Analyzer getting the info for the ... response: 'affected)' ...
    (microsoft.public.sqlserver.programming)
  • Re: Error Trying to VIew data in table
    ... you should view/manipulate your data in SQL Server's Query Analyzer. ... this will tell you whether the problem is with Enterprise ... Manager, or more deeply rooted. ...
    (microsoft.public.sqlserver.server)
  • Re: Show Line Numbers?
    ... ....but that will not show you the line number in your Query pane. ... SQL Express Manager, you'll actually have the line numbers available so ... > Have you tried the "Grid" output mode in Query Analyzer? ...
    (microsoft.public.sqlserver.tools)
  • Re: Data Access 2003 PJDB.htm
    ... SQL because it is plays into my skill set. ... "Distributed actuals" represent the need to include what we call our Value ... As he is a manager as well, he may have some flexability in terms of how he ... Project Server is terrific. ...
    (microsoft.public.project)