Re: Problems with new security patch....
From: Arvind Krishnan[MS] (arvindk@online.microsoft.com)
Date: 10/30/02
- Next message: Graham Harris: "Re: POST SP2 HotFixes a pain.."
- Previous message: Arvind Krishnan[MS]: "Re: POST SP2 HotFixes a pain.."
- In reply to: Johnnie Miami: "Re: Problems with new security patch...."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Arvind Krishnan[MS]" <arvindk@online.microsoft.com> Date: Wed, 30 Oct 2002 13:12:46 -0800
Johnnie,
Would it be possible for you to work with SQL Server Product Support to see
if we can gather more information about your specific problem and see if it
is indeed related to the new patch? We did not see this problem during our
testing, and so, any help you can provide in helping us resolve this is much
appreciated.
-- Thanks, Arvind Krishnan SQL Server Development Team Microsoft Corporation -- This posting is provided "AS IS" with no warranties, and confers no rights. "Johnnie Miami" <johnnie_miami@yahoo.com> wrote in message news:egjjIxDfCHA.1760@tkmsftngp12... > Hi Arvind! > After we installed the patch we had problems with queries of this nature > It through errors like: > > Microsoft OLE DB Provider for SQL Server error '80040e14' > > SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005 > EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. > > Here is a sample query. I have changed the fieldnames, tablenames to keep > things private. > Select D.EID, D.EName, P.PID, d.TID From (Select E.EID, E.EName, te.TID From > MyETable E, MYTETable TE Where TE.EID = E.EID And TE.TID =" & > Trim(tRs.Fields(0)) & ") D > Left Outer Join (SELECT * FROM MYPETable WHERE PID = " & projectID & ") P ON > D.EID = P.EID AND d.TID = p.TID > > Queries like this had been running since May. Once we broke these queries > up we did not get the errors. > > Thanks. > > > "Arvind Krishnan[MS]" <arvindk@online.microsoft.com> wrote in message > news:#MDmUWueCHA.2672@tkmsftngp11... > > Johnnie, > > Would it be possible for you to post a script that would help me reproduce > > this problem? > > > > -- > > Thanks, > > Arvind Krishnan > > SQL Server Development Team > > Microsoft Corporation > > -- > > This posting is provided "AS IS" with no warranties, and confers no > rights. > > "Johnnie Miami" <johnnie_miami@yahoo.com> wrote in message > > news:#W5j2udeCHA.2548@tkmsftngp10... > > > Since apply the new Elevation of Privilege in SQL Server Web Tasks > > > (Q316333)(Microsoft Security Bulletin MS02-061), we have nested > subqueries > > > that are no longer working. These queries are now throwing this error: > > > > > > Microsoft OLE DB Provider for SQL Server error '80040e14' > > > > > > SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005 > > > EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. > > > > > > Anyone else experience this? > > > > > > This is on SQL Server 2000. > > > - Johnnie > > > > > > > > > > > >
- Next message: Graham Harris: "Re: POST SP2 HotFixes a pain.."
- Previous message: Arvind Krishnan[MS]: "Re: POST SP2 HotFixes a pain.."
- In reply to: Johnnie Miami: "Re: Problems with new security patch...."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
