SQL Server 2005 Express

From: Mark (field027_at_idonotlikejunkmail.umn.edu)
Date: 11/04/04 

Date: Thu, 4 Nov 2004 11:40:42 -0600

I've installed VS.NET 2005 Beta along with SQL Server 2005 Express Beta on
the same machine. I'm interested in connecting to SQL Server via query
analyzer (2000 version) or a similar tool.

I want to be able to:
1. Execute multiple statements at a time (create table, insert into, backup
database, restore database, etc.)
2. Highlight one of the statements in a script and execute it on its own.

What's the best way to do this while avoiding using OSQL or similar? I was
surprised the Query Analyzer (2000 version) didn't work with it right out of
the box.

Thanks in advance.

Mark

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: 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)
  • Re: Relation between reads and duration
    ... I don't recall the details now, but I think the beta 1 ... maybe the situation will improve in future versions of SQL Server. ... because the data rows requested by the query are bunched ...
    (microsoft.public.sqlserver.server)
  • Re: multiple times execution of procedure
    ... If Query ... Analyzer told you that then it might not be accurate because it can't give ... server or what happened with the network link between SQL server and the ... concurrently and it executes that in an iteration M times. ...
    (microsoft.public.sqlserver.programming)
  • Re: Tools with/for Express
    ... Enterprise Manager does not work with SQL Server 2005. ... Analyzer is pretty dumb and just passes on what you type, ... But Enterprise Manager tries to write it's own code and it doesn't use SQL ... I then attempted to use Query Analyzer. ...
    (microsoft.public.sqlserver.tools)
Loading