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


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.






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. 


  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


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