Renaming Root “Title” Site Column – Powershell Example
The other day I had to correct a friends SharePoint site column and feel like tossing out a quick blog about it. Sometimes what happens is you begin digging into a content type, go a bit too far and modify the wrong site column, not the inherited one, but the actual title column used for an entire site collection.
Ok, so just change it back right? Unfortunately that’s when you will run into the message: “The column name that you entered is already in use or reserved.”
Microsoft has a nice support article on it here: http://support.microsoft.com/kb/923589 and many SharePoint community members have blogged about workarounds such as Bob Mixon (http://masteringsharepoint.com/blogs/bobmixon/archive/2008/08/22/have-you-ever-changed-the-top-level-site-title-site-column.aspx). Bob does a great job of outlining a Powershell script here that can be easily used to update the column.
Here is the script Bob provides. I have tweaked it to ensure the web and site objects are properly disposed of (http://blogs.msdn.com/sharepoint/archive/2009/02/11/sharepoint-and-powershell-knowledge.aspx).
#Replace the siteurl with your targeted site collection url.
$siteurl = “URL of top-level site”
$spfield.Title = “Title”
PowerShell for Windows 2003 SP1 can be downloaded from here:
X86 – http://go.microsoft.com/fwlink/?LinkID=75790&clcid=0x09
X64 – http://go.microsoft.com/fwlink/?LinkID=75791&clcid=0x09
Hope this helps someone,