Post reply

Query Analyzer execute queries on the Client or Server?

  • July 1, 2005 at 2:21 pm

    #89930

    We have SQL Server 2000 SP3. My question is when I execute a query from Query Analyzer on my laptop (client machine) is the code being executed on my machine or the SQL Server?

  • July 1, 2005 at 4:41 pm

    #570465

    Your machine sends the SQL to the server to be executed.  The optimization and data retrieval happen at the server.  If you unplug from the network, you can't run the SQL (unless you are running SQL Server locally on your laptop).

    And then again, I might be wrong ...
    David Webb

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply