Change BCS throttle limit of 2000 rows

One of my developers was getting a connection timeout on using an External Content Type. The real problem was that BCS has a limit of 2000 rows returned in a query. Here’s a PowerShell script to edit that limit:

$wthbcs = Get-SPServiceApplicationProxy | where{$_.GetType().FullName -eq (‘Microsoft.SharePoint.BusinessData.SharedService.’ + ‘BdcServiceApplicationProxy’)}

 $BCSThrottle = Get-SPBusinessDataCatalogThrottleConfig -Scope database -ThrottleType items -ServiceApplicationProxy $wthbcs

 $BCSThrottle

 Set-SPBusinessDataCatalogThrottleConfig -Identity $BCSThrottle -Maximum 1000000 -Default 20000

Download SharePoint 2010 Demo VM

SharePoint 2010 and Office 2010 Hyper-V VHD files are now available for download. It’s spit up in 23 files for SharePoint 2010. This includes Windows Server 2008 R2, SharePoint 2010, Office 2010, Visual Studio 2010, SQL Server 2008 R2. Theres 2 more VMs for Exchange and Communicator.

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=27417