.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Row size error

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :Sql Server
Hello, I'm getting again row size errors: Cannot sort a row of size 32826, which is greater than the allowable maximum of 8094. Consider resubmitting the query using the ROBUST PLAN hint.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. The fields I do the operation on are 1 smalldatetime field and 11 int fields, which doesn't even get close to the maximum size, so I just don't understand what's wrong! Thanks for any help.  

View Complete Post

More Related Resource Links

AsyncFileUpload: Throw Error on image size


I have an AsyncFilUpload that is used to upload  to my site. On the server side I have code that checks the width and height of the image and will only save the image if it is within the limits buit I can't figure out how to get the AsyncFileUpload control to show an error when this happens. Can anyone give me any pointers?


error code for size limit reached

What is the error code, when the DB reaches the 10GB limit. I just wasn't ready yet to check the 36.000 error codes of SQL Server 2008 R2.

WCF To WM6 Maximum Message Size Quota Error



I am having some trouble with an error message that keeps popping up on a handheld application. It says 'The maximum message size quota for incoming messages (65536) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element.'

The app talks to a WCF service I've created and after googling around a bit, I discovered the MaxReceivedMessageSize value needed to be set.  However, after doing so in WCF service and setting the bindingConfiguration property to the correct binding element, the same message appears on the handheld.  The handheld app has no binding elements within the .config file and I tried adding the same binding data to this config file but the handheld crashes. What should I do?

Here's the server config binding data:


  <diagnostics wmiProviderEnabled="false">

Reports rendered in R2 now give an error ; Must be non-negative and less than the size of the collec


Hi, the full error is

An error occurred during client rendering. Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index

We have many reports that were working fine on the old 2008 business intelligence reporting services.  When we launched the rdls on a R2 bids server, we received the above error.

The way we fixed this was by trial and error and found a text box caption and text box expression that was too 'skinny'. We widened it vertically and it worked. No widths were negative numbers, just too 'skinny' it seemed.  Again, the text box vertical width worked fine in the old bids.

Ok, so what's our problem?  Well, we have dozens of reports now throwing this error.  The field text boxes are not all the same on the reports. We can go through each report and spend an hour trying to figure out what text box is the problem. This will be time consuming. Any patches from ms or advice how to do this quickly???


SSAS error log file size growing




We have a SSAS server 2005 running on a 64 bit server.

This server generates a error log file under D:\MSSQL\MSSQL.2\OLAP\Log\Error_Log.Log

This file is growing enormously. its current size is around 112 GB which is 5 times the size of the cube itself.

Is there any way we can control the size of this file by setting any max size property in the SSAS server.

any help would be highly appreciated.






Buffer Size error when retrieving Metadata - How to increase size?


I am trying to retrieve the MetaData from the WCF Service using the following method.

// Create a MetadataExchangeClient for retrieving metadata.
EndpointAddress mexAddress = new EndpointAddress( uri );
MetadataExchangeClient mexClient = new MetadataExchangeClient( mexAddress );
// Retrieve the metadata for all endpoints using metadata exchange protocol (mex).
MetadataSet metadataSet = mexClient.GetMetadata();

How do I increase the buffer size?


Export to Excel big size files (10000 pages) - HTTP Error 401.1



If you attempt to export a file to Excel, the browser hangs for a long time, then begins to request authorization, several times in succession .
Then displays an error message: "you are not authorized to view this page"

Maximum message size quota for incoming messages (65536) error


Currently I'm developing a windows phone 7 application which accesses web service. However, when I accesses the web service there's an error said :

"The maximum message size quota for incoming messages (65536) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element."

Yes, I have tried to modify the MaxReceivedMessageSize property in the ServiceReferences.ClientConfig, but it seems the application turn it back to default size when we accessing the web service.

ServiceReferences.ClientConfig :

                <binding name="Contracts277001Soap" maxBufferSize="2147483647"
                    <security mode="None" />

Reduce ASP.NET Page size and complexity using JQuery

This is my first post on asp.net blog. ASP.NET Ajax and JQuery are two different ajax framework. In this post I will show, how we can enhance gridview using ASP.NET Ajax and JQuery. I also compare the implementation of these frameworks. In next posts i will explain more about JQuery and ASP.NET Ajax and also tell you "How to combine the power of both framework". My Future post will related to ASP.NET and related frameworks.

IsapiModule Error 500 Issue


I am about exhausted trying to figure out this error:

HTTP Error 500.0 - Internal Server Error

Description: The page cannot be displayed because an internal server error has occurred.

Error Code: 0x8007007b

Notification: ExecuteRequestHandler

Module: IsapiModule

Requested URL: http://localhost:80/ReportServer

Physical Path: c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer

When I enable Failed Request Tracing Rules and view the log output I am supposing that the actual problem is in the 2nd call where there are 2 backslashes before the actual filename in the specified path:


CALL_ISAPI_EXTENSION DllName="C:\Windows\Microsoft.NET\Framework\v2.0.50727\\aspnet_isapi.dll"


Handling 404 page not found with Error page



      How do i handle 404 page not found?

Inserting personal error message in ValidationSummary



I am creating a web form that requires a lot of validation. I use many of the validation control in asp.net already like RequiredFieldValidator and CompareValidator. 

My Problem: after my custom validation for the value entered return an error message, and I pressed enter key when the field is empty, my custom error message is overlapped by my ValidationSummary. 

Setting my custom error to visible = false on button click also does not seem to work as it requires for me to enter the value first.

This made me think, is there a way to insert my custom validation inside the ValidationSummary as an error message like for other validation control?

Thanks in advance

Set Custom Paper size in C#.net 3.5


Dear All,

I have to set custom paper size 6X8 inches

plz tell sugest me code how to do it.

in C#.net 3.5

i m using Asp.net 3.5 Crystal report

i have to do it programiticlly



Sys.Net.WebServiceFailedException: The server method '' failed with the following error:



Let's say we have 2 time consuming functions, aaa and aaa1 inside a aspx page.

        public static string aaa(int i)
            return i.ToString();

        public static string aaa1(int i)
            return i.ToString();



        <asp:ScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="true">
        <span id="displayspan"></span>
        <br />
        <input type="button" value=

Jscript error: Object does not support property or method


 Hi, i have little knowledge on javascript but i need to use this code get from somewhere for a jquery to work.

I face this "Jscript runtime error: Object does not support property or method" whenever im trying to run this page.

In my experience, im get this error msg 9 out of 10 times i use javascript in my system.

Im using Microsoft Visual web developer 2008, i wonder if this is related to my problem, i not sure there is anything i need to add as reference or update anything.

But anyway, in short, i just couldn't use javascript code when using this development tool because of this sort of error.

Anyway, it happen that last time i tried use the same type of jquery code in another project and it seems to work well without an error.

But now when im try to use it again in this recent project i created, it come out with this error and i have no idea how to solve it even look through google and this forum.

It doesn't really seems like its the code problem itself although im not sure, because any javascript code just couldn't work.

So below is my code that i need to use.

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js" ></script>
<script type="text/javascript" src=&quo

Type or namespace error.


A couple of days ago I started getting an unusual behavior when compiling Website projects. I have referenced class libraries added to my bin folder that are also correctely referenced in using statements in my aspx.cs code behind. When I compile, I get the 

Error 4 The type or namespace name 'CommonClassLibrary' could not be found (are you missing a using directive or an assembly reference?) C:\Dev\Fiscal_Portal\Implementation\FMS Portal Site_new\App_Code\BLL\DataTables.cs 1 7 C:\...\FMS Portal Site_new\

The type or namespace name 'CommonClassLibrary' could not be found (are you missing a using directive or an assembly reference?)

error message that would typically be received when the dll has not been added as a reference or added in a using statement.

I can eliminate the error by adding an


HTTP Error 403 - Forbidden


(VB Express website directed me to ASP.NET Web Services which in turn redirected me to this forum).

 Hopefully someone can help me here...... 

I am using VIsual Web Developer and downloaded the small business application to use as a starting point to help my wife get a website up for her small business. When I load the application, I can F5 and it runs fine but as soon as I make any modification to the app and hit F5, I get the HTTP Error 403 - Forbidden when it tries to show the website.

I notice a pop up that occurs when I run that allows me to choose the link for my app and it displays correctly (I close the webpage that has the error on it).

This seems like a pain, is there a setting I'm missing - I would think that this should "just work".

What's up?????



ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend