Link to home
Start Free TrialLog in
Avatar of JDSX
JDSXFlag for United States of America

asked on

Hwo to cache proc to avoid warnings?

I have two SQL 2000 databases, one my dev and one a client's.  On mine, if I execute a proc with some parameters, the first time I get some warning messages but the second time with the same params I don't.  On the client's, I get the warnings every time.  The warnings themselves can't be suppressed but why does one cache and the other not?
Avatar of chapmandew
chapmandew
Flag of United States of America image

Why don't you post the warnings that you get?
Avatar of JDSX

ASKER

This is an example of the warning:
Warning: The table '#group_summary' has been created but its maximum row size (8469) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.

I know why I get it, I don't want to suppress it.  In fact I don't think it's even possible to suppress it.  What I want to know is why in one database this error only appears at the first execution and in the other database it appears every time. Thanks.
Are the service packs the same between the two machines?
Avatar of JDSX

ASKER

No.  The one that doesn't repeat the warning has SP4, the other is SP1.  Was there something released in a service pack to affect this?
Avatar of JDSX

ASKER

Actually I take it back, I read it wrong.  Here's the @@VERSION output:

--Microsoft SQL Server  2000 - 8.00.2039 (Intel X86)   May  3 2005 23:18:38   Copyright (c) 1988-2003 Microsoft Corporation  Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
--Microsoft SQL Server  2000 - 8.00.2187 (Intel X86)   Mar  9 2006 11:38:51   Copyright (c) 1988-2003 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

The first is the one that doesn't repeat.
If I were a betting man, I'd bet that was your problem....
Avatar of JDSX

ASKER

I'll update the first and see what happens.
Avatar of JDSX

ASKER

It's not the service pack.  I hate working with ASP because there's no apparent way to handle recordsets containing these unsuppressable warnings.
ASKER CERTIFIED SOLUTION
Avatar of JDSX
JDSX
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial