How to make Dataview Web Part Portable?

February 27, 2012    , ,
When working with SharePoint DataView Customizations, by default you can not just copy paste the data view pages into new environment or even restore them from backup. This is because: The Data View Web Part uses List ID instead of List Name. So, How to make the Dataview Portable from one envi…

What is my SQL Server Version, Service Pack, Edition

February 24, 2012    ,
Requirement: Wanted to check the installed SQL Server version service pack level. SELECT @@version ? It didn't give me the Service pack information. Query to Check SQL Server version, Service pack and Edition: SELECT SERVERPROPERTY('productversion') [Product Version], …

Install PowerShell in Windows 2003

February 23, 2012    ,
Need PowerShell in Windows 2003?  Install "Windows Management Framework core" which includes Windows PowerShell 2.0. You need to have SP2 or later in Windows 2003. Go the KB: http://support.microsoft.com/kb/968929 , download and install the appropriate KB for your environment (such a…

Version History Size Report for Entire SharePoint Web Application

February 19, 2012    , , , , ,
Ever wanted to get a report on versioning sizes on SharePoint? Unlimited No. of versions enabled in various document library across web application. As part of regular auditing, wanted to generate report for the entire web application ,with Number of versions, Amount of storage consumed by versio…

How to Deploy and Activate Sandboxed Solutions in SharePoint 2010

February 17, 2012    , , ,
Sandboxed solutions brings the benefit of deploying solutions to SharePoint Server without affecting any other process outside the sandbox. SharePoint 2010 Sandboxed solution can be deployed by Site collection administrators. Here is the guide on How to Deploy and activate sandboxed solution in …

Fix "The site collection containing this sandboxed solution has exceeded its daily resource usage quota."

February 17, 2012    , , , ,
When trying to activate a sandboxed solution, Got below error message: "The site collection containing this sandboxed solution has exceeded its daily resource usage quota." Solution:  This is because of the Sandbox solution resource limit. To fix this issue, just increase the site …

Get the List Settings Page of any List

February 15, 2012    ,
Problem: There was a List in a site collection without any tool bars (They were removed purposefully). Had to change some columns in the list. Since the toolbar is disabled, could not get into : List settings from SharePoint Interface. Solution: For user created lists, the simplest way is, n…

Find Large Lists & Generate Report in SharePoint

February 15, 2012    , , , , , ,
Requirement: SharePoint was running with serious performance issues and wanted to get the report, where more than 2000 items stored in List/Library for the entire web application. When users store a large number of items in List or Library, SharePoint will definitely run into serious performanc…

SharePoint Search Scope Force Update

February 10, 2012    , ,
After updating SharePoint Search Scope, it said: wait 14 Minutes to update. How to instantly update the scopes? Do we have to wait for 14 Minutes? Is there a  way to force SharePoint search scope update on-demand? Definitely, Yes! We can force update SharePoint 2010 search scope. Just go back to…

SharePoint Alert Notifications Not Working - Checklist for Troubleshooting

February 08, 2012    , , , , , ,
Before proceeding with the checklist, analyze and isolate the issue: Whether E-mail Infrastructure is working on your environment Whether in all SharePoint web applications alerts are not working? SharePoint alerts not working for one site? SharePoint alerts not working after upgrade or migr…

"Unable to complete this operation. Please contact your administrator" Error when trying to upload a file in SharePoint

February 07, 2012    , , , ,
I was troubleshooting an issue with uploading files to SharePoint Site. When I tried uploading a file to the document library, I got this error: "Unable to complete this operation. Please contact your administrator" Enabled Stack Trace and Disabled Custom error tags in web.config …

Find Remaining of Days in XSL

February 07, 2012    ,
Scenario: I have a List for keeping track of my Outsourced resources with fields: Resource Name, Skills, Contract Start Date, End Date, etc. What I want is: Display the No.of remaining days in a page. So Added a calculated field , applied the formula : =IF(Today>=[End Date],0,INT([To Date]-…

Powered by Blogger.