SQL Server Shrink Log File

SELECT name,recovery_model_desc FROM sys.databases
GO 

 Step 1
ALTER DATABASE <Your Database Name> SET RECOVERY SIMPLE; 
ALTER DATABASE WSS_Proposal_Content SET RECOVERY SIMPLE;

Step 2
DBCC SHRINKFILE (<Your Database Name>_log, 5); 
DBCC SHRINKFILE (WSS_Proposal_Content_log, 5);

Step3
ALTER DATABASE <Your Database Name> SET RECOVERY FULL; 
ALTER DATABASE WSS_Proposal_Content SET RECOVERY FULL;


Database 1
Alter database SharePoint_Config set Recovery simple
GO

USE [SharePoint_Config]
GO

DBCC SHRINKFILE (N'SharePoint_Config_log' , 50)
go

Alter database SharePoint_Config set Recovery full
GO


Database 2
Alter database WSS_SESProposal_Content set Recovery simple
GO

USE [WSS_SESProposal_Content]
GO
DBCC SHRINKFILE (N'WSS_SESProposal_Content_log',50)
go

Alter database WSS_SESProposal_Content set Recovery full
GO


Database 3
Alter database WSS_Search_Content set Recovery simple
GO

USE [WSS_Search_Content]
GO
DBCC SHRINKFILE (N'WSS_Search_Content_log',50)
go

Alter database WSS_Search_Content set Recovery full
GO

Find Logical File Name
Declare @LogFileLogicalName sysname
select @LogFileLogicalName=Name from sys.database_files where Type=1
print @LogFileLogicalName

Creating Custom Action in External Content Type (ECT) - SharePoint 2010.

How to create  External Content Type (ECT), See the below blog up to points 12,
http://makdns.blogspot.com/2012/12/integrating-dynamics-crm-2011-data-into.html

The new action will not be available in existing external lists of that external content type. Only new external lists of the appropriate external content type will display the action in the shortcut menu.

If you create External List (Point 13) before create new action, the new action won't display.

Integrating Dynamics CRM 2011 Data into SharePoint 2010

1. Open the SharePoint site in SharePoint designer 2010.
2. Select External Content Types and click External Content Type (ECT).
   
3. Use the following settings on it
   Name: CRM Board Entity
   Display Name: CRM Board Entity
   Click on link next to External System.
   

Dynamics CRM 2011 Integration with SharePoint 2010

The Dynamics CRM 2011 List component for SharePoint makes your CRM documents that are stored on SharePoint 2010 available to you in a format that has the look and feel of Dynamics CRM.

This component also enables Dynamics CRM to automatically create folders that will be used to store documents related to Microsoft Dynamics CRM records on SharePoint. It also display the SharePoint List in your CRM.

SharePoint 2010

1. Download the Microsoft Dynamics CRM 2011 List Component for SharePoint
2. Double Click the downloaded CRM2011-SharePointList-ENU-amd64.exe.
3. Select a folder to store the extracted files, and click OK.
   The following files are extracted: AllowHtcExtn.ps, crmlistcomponent.wsp, mscrmsharepointeula,txt.
4.  Open SharePoint Central Administration or Site Collection website.
5. Click Site Actions, then click Site Settings.
6. Under Galleries, click solutions.
7. On the Solutions tab, in the New group, click Upload Solution.
8. Click Browse, locate the crmlistcomponent.wsp file, and then click OK.

SharePoint 2010 - Create List, Update Document, Link to Other List using c#

This post contains mostly c# code. Code contains to create/update List, folder, link to other list and update word document.

using Microsoft.SharePoint.Client;

namespace CreateReportForPlacesV2
{
    public class SharePoint
    {
        // Defines a private SharePoint site, like "http://<Server Name>/"
        private string spSite = System.Configuration.ConfigurationManager.AppSettings["SPSite"].ToString();

        // Defines a private SharePoint document, like "Reporting Documents".
        private string spDoc = System.Configuration.ConfigurationManager.AppSettings["SPReportingDocument"].ToString();

        // Defines a private SharePoint place list name, like "Place Details".
        private string spPList = System.Configuration.ConfigurationManager.AppSettings["SPPlaceDetailsList"].ToString();

        // Defines a private SharePoint C list is used to link to Place list details.
        private string spCList = System.Configuration.ConfigurationManager.AppSettings["SPCList"].ToString();

Display SharePoint List in CRM Dynamics 2011

SharePoint 2010

1)Create a new View and type a name CRMView , and select “standard View”, select the display columnnames and also ZipCode column name, press OK to save the new view.