Results 1 to 2 of 2

Thread: Help requred

  1. #1
    Join Date
    Jun 2004
    Location
    Far away from heaven
    Posts
    194

    Unanswered: Help requred

    Hi, folks. The software seems very slow to open the forms. When i run trace on the application, i get the TEXT in the profiler like this:
    [quote]
    declare @P1 int
    set @P1=1
    exec sp_prepare @P1 output, NULL, N'SELECT * FROM orders_tab', 1
    select @P1
    go
    /[quote]
    SELECT * FROM orders_tab, is it really hapenning?
    orders_tab contains 2 lac records.
    I couldn't find sp_prepare in BOL.
    Any ideas?


    Howdy!

  2. #2
    Join Date
    May 2003
    Location
    UK
    Posts
    220
    Howdy

    Sp_prepare are SQL system commands. You wont find them documented.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •