HOW TO: Change file extension of an existing item in SharePoint document library

This post is a contribution from Aaron Miao, an engineer with the SharePoint Developer Support team. For various reasons, people want to change the file extension of an existing item in a document library.  For example, with SharePoint 2007, files with JSON extension in document library can be opened without problems.  However, once you upgrade…

4

SharePoint 2010: SQL limitations in lookup columns

This post is a contribution from Balaji Sadasivan, an engineer with the SharePoint Developer Support team. As most of you are already aware SharePoint stores both the person/group field and the metadata fields as lookup values internally. SharePoint dynamically creates a stored procedure to store the lookup values in SQL.  The stored procedure accepts a…

1