.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

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

Posted By:      Posted Date: October 05, 2010    Points: 0   Category :Sql Server



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

View Complete Post

More Related Resource Links

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

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

MVC2 issue - Stuck. Trying to create a cms with nested partials


I am currently trying to display multiple items on a single page. I am not sure as to how to tackle this. What I have is a database table that has all the page data in. I have this run as a PagesController and this works fine. However what I would like to do is, if say the Products page is selected via the menu, I want to pull back not only the Products page html but also get all the products, and even be able to pull them through via category. I was trying to use a partial view, but I can't get it to work. The same would be for other pages, having partial views to display the other content, ie if Gallery is selected, the page html for Gallery shows and it then can push to a partial view that pulls all the gallery images from the gallery db table and so on. 

Maybe I am tackling this the wrong way. I have the pages stored in the db to allow for a CMS system I have setup. Maybe I need to use models for all the other items(Products, Gallery, Videos and such) and use the partial for the page html?

Any help would be greatly appreciated as I am confused.

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

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

XmlReader.Create(textReader, XmlReaderSettings) Validation Issue

For the most part, when I perform an XmlReader.Read() I am catching validation errors based on my schemas.  This, however, is a large group of schemas with several imports and includes.  My question is why I'm having validation errors in two places that seem to be defined in the schema.   Here's an example:   Schema 1 (you can see that IdentificationType has sub-elements for IdentificationID and IdentificationCode):   <xsd:complexType name="IdentificationType">                 <xsd:annotation>                         <xsd:documentation>A data type for a representation of an identity.</xsd:documentation>                         <xsd:appinfo>                                 <i:Base i:namespace="http://niem.gov/niem/structures/2.0" i:name="Object"/>               &nb

Accordion size issue

Hi I am using AJAX Accordion as side menu that i fill at the run time from database i create the panes and the menu items all at run time the problem here is that i cant make the accordion match the height of the page. i change the AutoSize to "Fill" and to "Limit" but still does not work as wanted it just fill based on the first opened pane so if first opened pane has 2 items then the accordion will take the height of the initial status as the accordion status any idea how to do that?   This is the script    <cc1:Accordion ID="SideMenuAccordion" runat="server" SelectedIndex="0" HeaderCssClass="accordionHeader" HeaderSelectedCssClass="accordionHeaderSelected" ContentCssClass="accordionContent" FadeTransitions="false" FramesPerSecond="40" TransitionDuration="250" Height="100%" RequireOpenedPane="true" SuppressHeaderPostbacks="true" AutoSize="Fill"> <Panes> </Panes> </cc1:Accordion>

Report Builder 3.0 issue - can view existing rdl files but cannot create new reports

I have Report Builder 3.0 deployed on my local machine pointing to a remote SQL Server 2008 R2 instance outside of my local domain.  Within this local Report Builder 3.0 instance I am able to open up previously created rdl files from the remote SQL Server 2008 R2 instance that I am connecting to.  However, if I try to create a new report on my local instance of Report Builder 3.0 and attempt to use the same data source as was used to create these existing rdl files, I receive the error: "Unable to connect to data source. The user credentials provided in the connection string do not have permission to connect to Reporting Services."  So why can I open existing rdl files from this remote SQL Server 2008 R2 instance, but not create new ones even though I'm using the same data source as the existing rdl files?  Thanks, Mark

Windows.Forms.Label size change issue



In a Windows Forms application developed with VB2008 Express, Label controls change size the first time the .Text property is updated.


On a Windows XP Pro SP3 system where the app was developed the labels retain the size set at design time.  On other systems, one also Windows XP, one Windows 7, labels shrink (all to the same size independent of content) the first time their .Text property is updated.  Labels that do not have their .Text property updated retain their design size.

Additional information:

The labels all occur within a FixedPanel of a SplitContainer.
Salient properties for the Label controls:
Anchor: Top, Left
AutoSize: False
BorderStyle: FixedSingle
Dock: None
Enabled: True
FlatStyle: Standard
Image: None
Locked: False
Margin: 0,0,0,0

WPF Application Size Issue

I'm planning to work on a desktop application using WPF. My biggest concern is, how to distribute this application to my users. It seems size of the framework 3.5 is near 200 MB. My users are not expected to download and deploy this much size from internet. Please suggest any alternative for this problem.

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

Issue with the buffer size of DFT!!


Hi Team,

I have a question on defining buffer size in ssis dataflow task

Existing table with 207 rows size is 520KB. I have to load 10000 rows at the max, can I increase buffer size of the DFT to 26MB my server Ram is 2GB and I am running this on SQL Server 2000 database?



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.


Issue with Size Property has an invalid size of 0


In my code I have:

SqlParameter param = new SqlParameter("ID", id);
                param.Direction = ParameterDirection.InputOutput;
                wrapper.ParameterCollection.Add("StudentObjectiveID", SqlDbType.Int).Value = objectiveid;
                wrapper.ParameterCollection.Add("SessionID", SqlDbType.Int).Value = sessionid;
                wrapper.ParameterCollection.Add("StaffID", SqlDbType.Int).Value = staffid;
                wrapper.ParameterCollection.Add("EnteredDate", SqlDbType.DateTime).Value = entereddate;
                wrapper.ParameterCollection.Add("Achievement", SqlDbType.NText).Value = Achievement;
                wrapper.ParameterCollection.Add("SessionStudentID", SqlDbType.Int).Value = session_student_id;
                wrapper.ParameterCollection.Add("ImageName", SqlDbType.NVarChar, 255).Value = imagename;
                wrapper.ParameterCollection.Add("ActualDate", SqlDbType.DateTime).Value = actualdate;
                wrapper.ParameterCollection.Add("FileType", SqlDbType.VarChar, 10).Value = filetype;

                int result = wrapper.ExecuteNonQuery();
                id = (int)param.Value;

And in the relevant stored procedure I

How to go around the file size issue when uploading large files?



In my application the user uploads three files ( Resume, Cover Letter, Selection Creteria).

I want users not to upload more then 4 MB files, so In my web.confing file I have allowed max of 5 MB. <httpRuntime maxRequestLength="5000"/>. I did this so that I can validate the file and give user a message that they are trying to upload more then 4 MB file.

It all works fine if the user is only uploading resume. But if the user uploads all three files of size 4MB then my validation does not work and it goes to connection time out.

How can i handle the validation to check the file size of all 3 files?


create url issue


Hello Everyone,

Not sure what I am missing as this sounds too basic and straigh forward. Please  help!!!

I have a mvc application in which I am posting using the following code. On server side, I am creating a word document and saving it on the server. Then I want to return the URL to this document. It works fine on my local machine, but when deployed to server, its giving error.

            var resultUrl = $(sender).attr("href");
                        type: "POST",
                        url: resultUrl,
                        data: "NoticeMonth=" + $('select#NoticeMonth').val(),
                        success: function(result) {
                            window.open(result, "showData",
                        error: function(req, status, error) {
                            alert("Sorry! error occured. " + error);
            return false;

On the server side, I have

Null Value/ create new column issue in SQL


Hi, I have a database with year, month, area1, area2.  Area2 has null values in them, and i want to create a 3rd column that takes area2 value as default, but if there is a null value in the column, then it looks at taking the value from area1. 

The Third column is the kind of column that i would like to produce, but i am not sure how to write it.

See example below:

year month area1 area2

Block size issue



I am not sure where exactly to post my issue, so i thoguht the general area would work for now.  Please let me know if I should post this somewhere else....here goes:

I have a SQL 2008 cluster on Windpows 2008 R2.  I had a new admin add the SAN drives and they were never configured for 64K block size as recommended.  Once the cluster was built, the SQL install was completed and installed to one of the SAN drives.  now we have to reformat all of the drives and make them 62k block size.

Is it possible to cut and paste the SQL directories to another drive, format said drive, then cut and paste the directories back?

if not...

Is there a recommended procedure or tool available?


Do i have to just move forward with a complete uninstall/reinstall of SQL server?






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