Cannot create a row of size 12573 which is greater than the

DashboardContext context = new DashboardContext();

DataTable dataTable = new DataTable();

SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();

sqlDataAdapter.SelectCommand = new SqlCommand();

sqlDataAdapter.SelectCommand.CommandTimeout = 120;

sqlDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;

sqlDataAdapter.SelectCommand.CommandText = "STRPROCEDURE_Name";

sqlDataAdapter.SelectCommand.Connection = new SqlConnection(context.Database.Connection.ConnectionString);

sqlDataAdapter.SelectCommand.Parameters.Add("@StorePK", SqlDbType.UniqueIdentifier).Value = (object)storePk;

sqlDataAdapter.Fill(dataTable);

while calling that sqlDataAdapter.Fill(dataTable) function i am getting an exception "Cannot create a row of size 12573 which is greater than the allowable maximum row size of 8060."

can anyone please help me out by a resolution and how cn i limit the resultant row size to the its maximum size.

any help woukd be appreciated

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Salman Beg7y ago
Hi. SQL Server has a limitation of 8060 bytes per row. For more you can follow up with this link, https://dba.stackexchange.com/questions/105852/cannot-create-a-row-of-size-xxxx-which-is-greater-than-the-allowable-maximum-row
0