Re: MAX OPEN CURSORS EXEDED

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 09/03/04 

Date: Fri, 3 Sep 2004 12:19:53 +0200

Do you see the error in any SQL Server errorlog or event log. I do not recognize this is a SQL
Server error message. Perhaps it is the client app which is sending the error message? 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"glenn" <g_xxxxxxxxx@hotmail> wrote in message news:%23reFYoZkEHA.1656@TK2MSFTNGP09.phx.gbl...
> Hi Peter
>
> The system that is used, is a standard ERP system. The error occurs when
> the user are register an order with some itemsId. The strange is that this
> only occurs
> with som specific items.
> I donīt know much more about  it.
>
> /Glenn
>
> "Peter The Spate" <anonymous@discussions.microsoft.com> skrev i meddelandet
> news:55ab01c49195$5627cca0$a501280a@phx.gbl...
> > My first though is that you are declaring cursors without
> > putting in the DEALLOCATE CURSOR command.
> >
> > Can you give us a bit more of a description where and when
> > its happening.
> >
> > Peter
> >
> > "You can always count on Americans to do the right thing -
> > after they've tried everything else."
> > Winston Churchill
> >
> >
> > >-----Original Message-----
> > >I get the following error:  "MAX OPEN CURSORS EXCEEDED"
> > in MS SQL 2000 from
> > >the client.
> > >Does anyone know how I can fix this error
> > >
> > >Regards
> > >/glenn
> > >
> > >
>
>

Relevant Pages

  • Re: Connecting to a sql server database
    ... You are trying to use integrated security in your app (as is shown in the ... line numbered code where the connection string is shown). ... sql server, hence integrated security fails. ... > causing the error message and what the correction for this. ...
    (microsoft.public.dotnet.general)
  • Re: Invalid OLEVERB structure error 80040000 on DTS job
    ... >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >- I copied this DTS package from a 32 bit Windows Server 2003 system. ... >I would only get that error message in the Job History logs though. ...
    (microsoft.public.sqlserver.dts)
  • Re: MAX OPEN CURSORS EXEDED
    ... Are you sure its coming from SQL Server? ... > Hi Peter ... > The system that is used, is a standard ERP system. ... >> putting in the DEALLOCATE CURSOR command. ...
    (microsoft.public.sqlserver.server)
  • Re: Classic ASP connectionstring to SQL Server 2005
    ... So this connection string is in the VB6 dll? ... What is the error message? ... Provider cannot be found. ... can you ping the sql server? ...
    (microsoft.public.inetserver.asp.db)
  • Re: ANNOUNCEMENT: New SQL Server security tool - SQL Server 2000 Scan Tool
    ... > This posting is provided "AS IS" with no warranties, and confers no rights. ... >> computers running Windows 2000 or higher and can identify instances ... >> please state the version of SQL Server being used and the error ... >> error message text received, ...
    (microsoft.public.windowsxp.security_admin)
Loading