Error

Aug 6, 2015 at 8:18 PM
I get an "Invalid object name 'AllDocStreams'" error when I try to extract a file, or files from a SP2013 content database (in SQL 2012). Any ideas what could be going wrong? Granted this was written for SP2010, but I am hoping it can be adopted for 2013.
Developer
Aug 6, 2015 at 8:41 PM
Hi Dean

Yes you should be able to adapt it, just had a look at the database structure for SP2013 and not surprisingly it's changed. What was the AllDocStreams table is now called DocStreams and the Id field is now DocId.

It should be a simple case of changing the following SQL command
SqlCommand cmd = new SqlCommand(string.Format("select ads.content from AllDocStreams ads where ads.Id = '{0}'", file.ID), conn);

to

SqlCommand cmd = new SqlCommand(string.Format("select ads.content from DocStreams ads where ads.DocId = '{0}'", file.ID), conn);

Haven't got time to try it out at the moment but if you try that & let me know if it fixes it for you.

Regards
Andy
Aug 7, 2015 at 9:44 PM
Thank you, I appreciate the quick response. I will give it a try.

Dean Della Pella

Sent from my Windows Phone