Prevent saving changes that require the table to be re-created in SQL Server 2012

Problem:

When you try to save a table after you did modifications on this table you got a message:

Saving Changes is not permitted. The changes you have made require the follwoing tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created.

 

 

Solution:

 

Advertisements

Error When Creating TFS SiteCollection Portal In SharePoint 2010

When you trying to create TFS team project portal from Central Admin you get the following error:

Feature with Id ‘4e72d346-276f-47b3-8d10-56e474a4fe4a’ is not installed in this farm, and cannot be added to this scope. 

Solution:

  1. Ensure that you installed Visual Studio Team Foundation Server on all farm servers.
  2. Install the feature TfsDashboardBaseContent  manually using PowerShell.
    Install-SPFeature -path "TfsDashboardBaseContent"
  3. Re install the three WSPs files related to the TFS using PowerShell with -Force parameter, you can find those files in the following path C:\Program Files\Microsoft Team Foundation Server 2010\Tools\Templates
  4. Deploy the three solutions.

Calculated Column – Smart Column

Get the day name

TEXT([Created],”dddd”) ===> Saturday

TEXT([Created],”ddd”) ===> Sat

Determine the time is in day or night

IF(AND(HOUR([Created])>7,HOUR(Created)<18),”Day”,”Night”) ==> Day

Choose a value randomly based on current time

CHOOSE(MOD(TEXT([Created],”s”),2)+1,”V1″,”V2″)

Determine if the current list item changed or no

IF([Modified] > [Created], “Changed”, “Not Changed”)

Convert value to text

TEXT([Created], “yyyy|mm”) ==> 2012|04

Check whether the field is empty of not empty

ISBLANK ([Cost])

Choose Statement

CHOOSE(int, Val1, Val2, <up to 29>

Example : Choose(5,”V1”,”V2”,”V3”,”V4”,”V5”,”V6”) ==> V5