Error: 702, Severity: 20, State: 1 
Author Message
 Error: 702, Severity: 20, State: 1
I am intermitently getting this error:

"Error: 702, Severity: 20, State: 1"

followed by:

"Memory request for 2928 bytes exceeds the size of single page of 2044
bytes."

I suspect that it may be due to a rather large query.

But other than rewriting the query, does any one have any suggestions as to
how to get around it?

How do I increase the page sized used by a db (particvularly the tempdb in
this instance)?

Many Thanks,

Jeremy Anderson



Sun, 27 May 2001 03:00:00 GMT
 Error: 702, Severity: 20, State: 1

Quote:
> Subject: Error: 702, Severity: 20, State: 1

Jeremy,

Q.  Why do I get an error "Error: 702, Severity: 20, State: 1" running a SQL Server query?
(v1.0   9.12.1998)

A.  The full error for this continues "Memory request for 2928 bytes exceeds the size of single page of 2044
bytes."

This is a SQL bug and cannot be fixed other than by rewriting the query in a different way - there is no way to expand SQL's page size.

Some reasons for this bug are already documented in http://support.microsoft.com - just search on 702 and SQL.  If your problem does not match any of these and you have already applied the latest service pack then either post a reproduction script for an
MVP to report for you or call the problem in to MS PSS yourself.

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please post ALL replies to the newsgroup only unless indicated otherwise)
 For SQL FAQ entries see www.ntfaq.com/sql.html
 and http://www.swynk.com/friends/hotek/articles/sqlserverfaq.asp
 and GO MSSQL lib 1 on Compuserve



Sun, 27 May 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Error: 17803, Severity: 20, State: 14 Insufficient Memory

2. Error 17805 Severity 20 State 3

3. Error 17805 Severity 20 State 3

4. Error: 1534 Severity: 20, State: 1 Extent:15480 not found in shared extent directory

5. Error: 1501, Severity: 20, State: 1 Sort failure..

6. Error : 827, Severity: 20, State: 1

7. Error: 3624, Severity: 20, State: 1.

8. System10 Error 423 Severity 20 State 1

9. Error 706 Severity 20 State 3

10. 1534, Severity: 20, State: 1

11. Error 9003 , Severity 20 : cannot recover master database

12. Error 613, Severity 20


 
Powered by phpBB® Forum Software