SharePoint 2010 limit exceeded in BCS

Connector has throttled the response. The response from database contains more than '2000′ rows. The maximum number of rows that can be read through Database Connector is '2000Connector has throttled the response. The response from database contains more than '2000′ rows. The maximum number of rows that can be read through Database Connector is '2000

Check limit

$bcs = Get-SPService
PS C:\Users\administrator> $bcs = Get-SPServiceApplicationProxy | where{$_.G
etType().FullName -eq (`Microsoft.SharePoint.BusinessData.SharedService.' + `BdcServiceApplicationProxy')}
PS C:\Users\administrator>
PS C:\Users\administrator> $BCSThrottle = Get-SPBusinessDataCatalogThrottleConfig -Scope database -ThrottleType items -ServiceApplicationProxy $bcs
PS C:\Users\administrator>  $BCSThrottle

Scope        : Database
ThrottleType : Items
Enforced     : True
Default      : 2000
Max          : 1000000

Set Limit to 50000

PS C:\Users\administrator>  Set-SPBusinessDataCatalogThrottleConfig -Identit
y $BCSThrottle -Maximum 1000000 -Default 50000
PS C:\Users\administrator>  $BCSThrottle = Get-SPBusinessDataCatalogThrottle
Config -Scope database -ThrottleType items -ServiceApplicationProxy $bcs
PS C:\Users\administrator>
PS C:\Users\administrator>  $BCSThrottle

Scope        : Database
ThrottleType : Items
Enforced     : True
Default      : 50000
Max          : 1000000

Restore Lost User when restoring from full DB backup in SQL Server 2008

MS SQL Server 2008 R2

To fix user login from the restored full db run the query below

EXEC sp_change_users_login 'Auto_Fix','user1',NULL,'mypassword'

Could not save the list changes to the server. This list cannot be deleted.

When SharePoint 2010 list becomes unavailable to delete.

error message: Could not save the list changes to the server. This list cannot be deleted.

solution: run powershell command as administrator type-in the ff:

$web = Get-SPWeb http://yourserver
$list = $web.Lists["MyList"]
$list.AllowDeletion = $True
$list.Update()

Now go to your list settings again and you'll see the delete command or you can just run the line below:

$list.Delete()

hope that helps!

saving it is not permitted because the changes you have made require the listed tables to be dropped and re-created.

Problem: Saving always warns you that it is not permitted because the changes you have made require the listed tables to be dropped and re-created.

Solution: In SQL Management menu go to Tools menu, click Options, expand Designers, and then click Table and Database Designers. Select or clear the Prevent saving changes that require the table to be re-created check box.

Cheers!

How to enable developer dashboard

This is will display helpful information regarding the call stack, database query times, exception information in error messages, and loading events for web parts during page rendering and will appear at the bottom page view.

stsadm -o setproperty -pn developer-dashboard -pv OnDemand (Recommended Setting)
stsadm -o setproperty -pn developer-dashboard -pv on
stsadm -o setproperty -pn developer-dashboard -pv off

It can be enabled via STSADM or PowerShell.
The property value set OnDemand will provides you the ability to toggle the dashboard on and off.

How to add role DC using Windows Server 2008 R2

been lazy to write an article about creating a DC role in win2008R2 so here is a helpful link with step by step snapshot of actual installations:

Running Windows Server 2008 R2 Installing DC

Dreaded 503 After SP2010 Installation

after a 'successful installation of SP2010' application pool for 'Central Administration v4.0 is stopping due to WAS error: 5059, this happen when a domain group policy is implemented. There are tons of solutions you can easily found by googling this error and probably would suggest editing of applicationhost.config or even adding of service account in 'login as batch', however these might or might not solve your issue.

Specially when you don't have the privileged to edit the GPO or even the local policy is locked because the 'Domain Group Policy' supersede the local policy.

Note: I used my standard domain account that has full privileged to both SQL Server and Local Server.

Changing Application Pool Identity to Network Service will run OK but will encounter Database connection failure, even if you give the identity dbcreator or sysadmin server role.

To make the story short:

Solution that works for me is to use local account in the SP configuration(I wouldn't advice this unless for testing purposes only). Yeah I was aware that local account is for stand alone only and SP GUI wouldn't allow local account to be used as Database Access, but there is a clever workaround here.

POWERSHELL is you friend!

After installing SharePoint 2010 do not run the Config wizard yet. make sure that there are no created SharePoint Admin and Config database, if so just delete it and application pools as well.

Note:

Run the "SharePoint 2010 Management Shell" by using Administrator rights. Click the Icon and select 'run as administrator', otherwise you'll encounter registry write error. Don't make me say I told you so! :P

Type and execute the command below:

PS> C:\Users\ New-SPConfigurationDatabase

cmdlet New-SPConfigurationDatabase at command pipeline position 1
Supply value for the following parameters:
DatabaseName: SharePoint_Config
DatabaseServer:
FarmCredentials
Passphrase:
-

after a successful creations of SharePoint Admin and Config databases. Run the SharePoint Confguration GUI wizard again and connect the created databases.


Update: 4/29/2011

THIS WILL WORK ONLY IF YOU'LL USE LOCAL ACCOUNTS (Farm and Complete installations)

For real solutions is to add ISS_IUSRS in 'logon as batch' when
global policy is implemented.

For reference: