June 20, 2008 at 2:00 pm
whenever I try to insert 35 million rows in view I get following error. Inserting data to other tables are fine. the probblem only occurs when I loading data to view. It gives me an error after 3 hrs of loading. when I check the count in the view, there are 0 records.
Msg 682, Level 22, State 148, Line 1
Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption.
June 20, 2008 at 3:03 pm
They are sql 2005 partitioned views
June 20, 2008 at 4:22 pm
Yes they are Partitioned Views then you need to supply all values required in table.
Something like this:
INSERT INTO vwDEMO
VALUES
(
''Mani1,
'Singh singh',
'Mani2',
'Owner',
NULL
)
Try to Run the insert into Batches. like fre records at a Time.
Maninder
www.dbanation.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply