Re: Problems with new security patch....
From: Johnnie Miami (johnnie_miami@yahoo.com)
Date: 10/25/02
- Next message: Narayana Vyas Kondreddi: "Re: archieving and deleting SQL 2000 table"
- Previous message: Lisa: "RE: VPN NT Authentication"
- In reply to: Arvind Krishnan[MS]: "Re: Problems with new security patch...."
- Next in thread: Arvind Krishnan[MS]: "Re: Problems with new security patch...."
- Reply: Arvind Krishnan[MS]: "Re: Problems with new security patch...."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Johnnie Miami" <johnnie_miami@yahoo.com> Date: Fri, 25 Oct 2002 11:33:24 -0400
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: Narayana Vyas Kondreddi: "Re: archieving and deleting SQL 2000 table"
- Previous message: Lisa: "RE: VPN NT Authentication"
- In reply to: Arvind Krishnan[MS]: "Re: Problems with new security patch...."
- Next in thread: Arvind Krishnan[MS]: "Re: Problems with new security patch...."
- Reply: Arvind Krishnan[MS]: "Re: Problems with new security patch...."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
