"Long query problem"

Article View: bit.databases.mssql-l

Article #109

Back to bit.databases.mssql-l Previous Next

#109

From: Ante �epi�
Date: Wed, 26 Jul 2000 00:00

7 lines
1304 bytes

Hi, I'm working with MS SQL 6.5 server. When I try to execute long query
(in fact 24 querys in union) I receive an error "Memory request for 2078
bytes exceeds the size of single page of 2044 bytes". If I remove one of
"selects" in the whole query or remove some table from relations in the
"WHERE" clause it works. 
What can be done?
Thanks!

Technical Details

Message-ID: <01bff703$d6286f80$0201c6c6@soft>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10f695,4eb709a38fabeaea,start
X-Google-Attributes: gid10f695,public
X-Google-Thread: 1589e7,4eb709a38fabeaea,start
X-Google-Attributes: gid1589e7,public
X-Google-Thread: f6611,4eb709a38fabeaea,start
X-Google-Attributes: gidf6611,public
X-Google-Thread: 104de1,4eb709a38fabeaea,start
X-Google-Attributes: gid104de1,public
From: "Ante �epi�" <infos@st.tel.hr>
Subject: "Long query problem"
Date: 2000/07/26
Message-ID: <01bff703$d6286f80$0201c6c6@soft>
X-Deja-AN: 650966478
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=ISO-8859-2
X-Complaints-To: abuse@tel.hr
X-Trace: as102.tel.hr 964617552 7718 195.29.241.27 (26 Jul 2000 13:19:12 GMT)
Organization: HiNet
Mime-Version: 1.0
NNTP-Posting-Date: 26 Jul 2000 13:19:12 GMT
Newsgroups: bit.databases.mssql-l,borland.public.database.sqlservers,comp.databases.ms-sqlserver,microsoft.public.sqlserver.server