Re: MAX OPEN CURSORS EXEDED

From: Roji. P. Thomas (lazydragon_at_nowhere.com)
Date: 09/03/04 

Date: Fri, 3 Sep 2004 16:00:11 +0530

This sounds like an ORACLE error!!!

Are you sure its coming from SQL Server? 

-- 
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.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: MAX OPEN CURSORS EXEDED
    ... Do you see the error in any SQL Server errorlog or event log. ... Perhaps it is the client app which is sending the error message? ... > Hi Peter ... >> putting in the DEALLOCATE CURSOR command. ...
    (microsoft.public.sqlserver.server)
  • Re: Mail Merge to SQL Server without using an external ODC
    ... but when the source changed to SQL Server it quit ... "Peter Jamieson" wrote: ... the interface) would be to distribute the *.odc file for the connection ... The distribution path you describe would require an installer, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Word 2003/Access2000/SQLSVR
    ... SQL server being where the data is held and this is accessed through a MS ... entire database and that may be say a record for Berkshire. ... "Peter Jamieson" wrote: ... replaced with the first record on the table in use. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: OpenDataSource SQL Server xpress problem
    ... Thanks a lot Peter. ... all the examples for Access files and none for SQL Server ... Open Data Source dialog, selecting the "Microsoft SQL Server" option, then ... 'Dim strConnect = System.Type.Missing ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Auto Exiting Store Procedures
    ... SQL Server will terminate the batch. ... "Peter" wrote in message ... > it is trying to put a char in an int. ... >>CREATE PROC my_proc ...
    (microsoft.public.sqlserver.programming)