sp_prepare, sp_execute

From: Jeigh (folkens.jason_at_acd.net)
Date: 06/07/04

  • Next message: Bill Ray: "Do updates kick tables out of cache?" 
    Date: Mon, 7 Jun 2004 12:29:49 -0400

    Hi.

    I have an application that queries an sql database through an ODBC DSN.
    Instead of quering the database directly, it uses sp_execute and sp_prepare.

    Because SQL Server 2000 now reuses execution plans, sp_prepare and
    sp_execute wont give me much of a performance increase.

    Is there a way that I can force the odbc DSN to not use the prepare/execute
    model, and instead send the queries directly to the SQL Server (so i can
    view them in sql profiler)?

    Thanks in advance,

    -- Jason

  • Next message: Bill Ray: "Do updates kick tables out of cache?"

    Relevant Pages

    • MS Query/ODBC/SQL problem
      ... a SQL database via an ODBC connection. ... the SQL database to a new server, ... Now those queries will not run. ... 2000, Microsoft SQL Server 2000. ...
      (microsoft.public.excel.misc)
    • Queries filling up SQL server!
      ... There are several of us using the same SQL database, ... on the SQL server, ... How can you have the queries stored in the ADP file, ...
      (microsoft.public.access.queries)
    • Re: Access Linked Tables Rights issue
      ... > permissions to the various users who need to use the data. ... > permissions don't count when it comes to SQL Server data. ... >>that links to tables in a SQL database. ... >>able to run the queries. ...
      (microsoft.public.access.externaldata)
    • Re: Access Linked Tables Rights issue
      ... You're going to need to get hold of your SQL Server admin to grant ... permissions to the various users who need to use the data. ... >that links to tables in a SQL database. ... >able to run the queries. ...
      (microsoft.public.access.externaldata)
    • Re: The best elegant solution to override 65k rows limit in a sheet
      ... Access ships with MSDE.. ... >SQL Server Books Online (again-- Access ships with freeware SQL Server ... better ways to achieve their results through queries. ...
      (microsoft.public.excel)
    Loading