.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

Cannot create a row of size 8068 which is greater than the allowable maximum of 8060

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :Sql Server
SQL2K5, SP3, both DB's in 2005 compatability mode. I have the same table in two DB's, that are on the same server. The table in both DB's appears identicle. However, on one of them we get the above error when attempting to do an Insert into the table, and one of them works fine. In 2000, the answer was to "use TEXT", but per BOL 2005, that data type is going away. All ideas are appreciated. CREATE   TABLE [dbo].[Complaint]( [ComplaintId] [int] IDENTITY(1,1) NOT NULL, [SourceId] [smallint] NULL, [MethodId] [smallint] NULL, [Location] [nvarchar] (50) NULL, [CurrentStatusId] [smallint] NOT NULL, [CreateDate] [datetime] NOT NULL, [CreateOpid] [char] (8) NOT NULL, [LastUpdateDate] [datetime] NOT NULL, [LastUpdateOpid] [char] (8) NOT NULL, [DESSiteCodeId] [smallint] NULL, [DESAdminId] [smallint] NULL, [Narrative] [nvarchar] (max) NULL,   CONSTRAINT [PK_Complaint] PRIMARY KEY CLUSTERED ( [ComplaintId] ASC )   WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] )   ON [PRIMARY] GO insert   into [dbo].[Complaint] (   Narrative,CurrentStatusId,CreateDate, CreateOpid ,LastUpdateDate,LastUpdateOpid) values   ('abc' ,1,current_timestamp,'dennis',current_timestamp,'dennis' ) TIA, ChrisRDBA

View Complete Post

More Related Resource Links

ISSUE: Cannot create a row of size which is greater than max 8060...Need Help




I have an issue related to maximum row size. I have a DW environment which has a table with multiple hierarchies and levels.


OLE DB error: OLE DB or ODBC error: Cannot create a row of size XXXX
which is greater than the allowable maximum of 8060. Errors in the OLAP
storage engine: An error occurred while the dimension, with the ID
of 'DATABASE', Name of 'DIMENSION' was being processed.
Server: The operation has been cancelled.

My current version is SQL Server 9.00.3257 (SP2 + CU 8). I would like to check if there is any upgrade available to fix this limitation (SQL Server 2005 SP3 / SQL Server 2008 SP1)....

Any advice is much appreciated.

Thanks in Advance

how to create a Bitmap with size(20000,30000) in c#

hi how to create a BitMap with size (20000,30000) using C#

Database Mail configuring the maximum mail size (not attachment 'MaxFileSize')

Hi can anyone tell me if it's possible to configure the maximum size of an email when using database mail?  I know it's possible to use sysmail_configure_sp to set 'MaxFileSize', I want to prevent an email being sent the size of the body of the email is very large. In my case the body is based on a query result set inserted as html. Thanks      

create polyline size relative to image clicked



i am creating a path geometry using polyline:


 System.Windows.Point Point1 = new System.Windows.Point(50, 10);
      System.Windows.Point Point2 = new System.Windows.Point(200, 10);
      System.Windows.Point Point3 = new System.Windows.Point(200, 100);
      System.Windows.Point Point4 = new System.Windows.Point(10, 100);
      System.Windows.Point Point5 = new System.Windows.Point(10, 50);
      System.Windows.Point Point6 = new System.Windows.Point(50, 10);
      PointCollection polygonPoints = new PointCollection();
      yellowPolyline.Points = polygonPoints;

this is a rectangle which is clipped from top-left,

actually i want to create dynamically a polyline whose size is relative to the image i click on the canvas 

and then apply than clip that image using that polyline,,so that the image looks clipped from top-left

how can

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">

The maximum message size quota for incoming messages (65536) has been exceeded.


I'm at my wit's end trying to resolve this error.  I am accessing a WCF Service with a Silverlight 4 application.  I have no issues retrieving large amouts of data from the service, but whenever I try to send it back to the service, I get thsi error.  Endless Bing seaches return essentially the same solution, but nothing seems to resolve it.  Below is my web.config:

<behavior name="">
<serviceMetadata httpGetEnabled="true" />

Maximum size of a WriteableBitmap (System.Windows.Media.Imaging.WritableBitmap)

I'm trying to find out the size limits on the WPF WritableBitmap class (ie. System.Windows.Media.Imaging.WritableBitmap, not the Silverlight class with the same name).
In the help for the BitmapSource base class it says:
"The maximum height and width of an image is 2^16 pixels at 32 bits per channel * 4 channels. The maximum size of a BitmapSource is 2^32 bytes (64 gigabytes) and the maximum image size is four gigapixels."
1. By my calculation, 2^32 bytes is 4 Gigabytes, not 64 Gigabytes. So is the size limit 2^32 (4 Gigabytes) or 64 Gigabytes (2^36)? 
2. Are the limits different on 32 and 64 bit versions of the OS?
3. Do these size limits also apply to the derived WriteableBitmap class, or are there further constraints based on available / addressable system memory and/or video (texture) memory?
Thanks in adva

Index (zero based) must be greater than or equal to zero and less than the size of the argument list

Hi, I have installed German and French language packs on my SharePoint 2010 server. After I change the Language settings to be able to select both the languahges as alternate language, I get this error:

Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

It is now not letting me change back the properties back to English only or opening the home page of the site.

Any idea, why this is happening and how can I disable this language pack option from this site collection only so that it works normally as before applying language packs? Do I have to unisnatll language pack for that?

Please guide.


MOSS 2007 - lowering maximum upload size


Hi everyone,

I’m about to lower the maximum upload size for one of my web application. I know there are few files already bigger than the new size I’m going to set. My sense is telling me the new lower size won’t affect the files already uploaded – but I thought I would ask in case anyone experienced anything unexpected?

Say my previous max upload size was 50 mb and now I’m going to set that to 25 mb and I already have files bigger than 25 mb sitting on my database. Do you see any problem with the new size would cause to the exiting files bigger than 25mb?

My environment is MOSS 2007 with SP2 applied and SQL server 2005 with SP3. All running on Windows 2003 Server with SP2.

Thank you in advance for sharing your experience!


WCF: The maximum message size quota for incoming messages (65536) has been exceeded


When using WCF services you may get the following error: "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." This error is given because of size limits set to responses in your application configuration.

You need to increase the value of two limiting parameters: maxBufferSite and maxReceivedMessageSize. In my example these values are set to 5000000.

<?xml version="1.0" encoding="utf-8"

Content database maximum size


I understand the database limit is 200Gb. I have added a few content databases as I expect my content to be in excess of 1Tb at peak usage. Where do I set it such that when the database reaches 200Gb then content starts getting stored on another content db and when that one also reaches 200Gb and so on.

Is this something I do in SQL or SharePoint

What is maximum insert commit size?

What is maximum insert commit size?
Mr Shaw

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" />

Is buffering or streaming required when response size is up to maximum of 5 MB.



I have created a WCF service. It has an operation contract as follows:


List<Report> GetData(string id);

Here the response (i.e. List<Report>) could be maximum upto 5 MB.

Will WCF handle this size response or I need to enable buffering or streaming.




What is the maximum size of binary data (varchar(max)) that 2005 merge replication can tolerate



Since we have experienced creating 2005 ent SP2 merge replication with 60 GB binary data requires 90 hours to finish the whole process(snapshot job + merge job), we just worry that if we still increase the database size to fill in such large binary image and it will finally make merge replication malfunctioning. Just want to ask is there any limitation on image sizes or db sizes if  merge replication need to replicate them? Do u have benchmark testing or experiment that can prove on this upperlimit?

Thanks and regards,




How to create 3 tier application using LINQ

As you know that in 3 tier architecture there are three layers

User interface layer. (Is our Form in Windows application and .aspx page in Web application)
Data Access layer. (Which provides interface between Business logic layer and Database)
Business Logic layer.(Which stores your application logic)

Create ToolTip for GridView Header

The following allows you to add a tooltip to the header links of your GridView, a feature that is lacking.
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