Re: SQL Login vs NT Login

From: Uri Dimant (urid_at_iscar.co.il)
Date: 07/27/05

  • Next message: Ajami: "Database Security" 
    Date: Wed, 27 Jul 2005 05:35:58 +0300

    Jonathan
    I have doubt abiout trusted connection causes to the problem. Have you
    investigated an execution plan of the queries? Does the optimizer available
    to use indexes?

    "Jonathan" <Jonathan@discussions.microsoft.com> wrote in message
    news:6559051D-D83A-46C2-BB36-FA2DB741EFEA@microsoft.com...
    > Hi all.
    >
    > My problem is simple.
    >
    > Last week I modify my application that connect to a SQL Server 7 to use
    > Windows Authentication. Before, it use SQL Authentication.
    >
    > Since I made that change, my application response slowly than before. I
    > use
    > exactly the batch of records, update, delete and insert and the difference
    > is
    > big. My application calculate some quantity and display it on screen.
    >
    > For exemple, for the same batch of record, with the SQL Authentication, it
    > takes 15 second but with the Windows Authentication, it takes more than 1
    > minute.
    >
    > Anybody have an idea ?
    >
    > I'm in the obligation to reinstall my old application because it's too
    > slow.
    >
    > Thanks
    >
    > Jonathan

  • Next message: Ajami: "Database Security"