TechNet Wiki

Tagged Content List

Wiki Page: SharePoint 2010: Access Denied By Business Data Connectivity Error in Using External Content Type List

Peter Geelen

Recently, an issue was reported where a site administrator tried to use a table in SQL server as an external content source. They were able to create the external content type based on this and had defined all CRUD operations. They also created a list based on this external content type. However,...

on24 Dec 2018
Wiki Page: SharePoint 2010: The Web Server at URL Does Not Appear

Peter Geelen

Recently one issue was reported to me where some of the administrators reported that they were unable to use SharePoint designer and while trying to open the sites they were getting the message "The Web server at URL does not appear to have Microsoft SharePoint Foundation installed". ...

on23 Dec 2018
Wiki Page: Excel Document opens as Read-Only and unable to check in the documents

Peter Geelen

Table of Contents Symptoms Common errors Scenarios Scenario 1: Excel Document open as Read-Only. Symptoms: Scenario 2: Unable to check-in back documents. Symptoms: Resolving Action Resolution: Scenario 1 Excel Document open as Read-Only. Resolution: Scenario 2 Unable to check-in back documents. Additional...

on23 Dec 2018
Wiki Page: SharePoint: "The storage space allocation page cannot be used for sites that do not have a storage quota defined"

Peter Geelen

Issue: User was getting error message below while accessing the Storage Space Allocation page: The storage space allocation page cannot be used for sites that do not have a storage quota defined. Background: While doing some regular clean-up of the sites which are over quota, I noticed...

on23 Dec 2018
Wiki Page: SharePoint 2010: PowerShell Script to List the documents checked out with version details in a Site Collection

Peter Geelen

Hi, I received a recent requirement to create a report that provides the details of checked out items in an entire site collection. This report should also contain data for the person whom the document is checked out to. It should also provide the version and if no version exists it should mention...

on23 Dec 2018
Wiki Page: SharePoint 2010: a spreadsheet method for quickly resolving missing non-upgrade-blocking dependencies

Stephan Bren

Introduction Resolving the various missing dependencies that surface in upgrade reports, like those generated by Test-SPContentDatabase, can be tedious, especially when there these are scattered about the site collection in no particular order and there are many hundreds of them to resolve. You...

on21 Dec 2018
Wiki Page: SharePoint 2010 Troubleshooting: July 2013 Windows Security Update Breaks SharePoint XSLT System Web Part Pages

Peter Geelen

Last week a Microsoft Windows Security Update was applied to a production server running Windows Server 2008 and SharePoint 2010. Following this patch, content owners using the Insert Link > from SharePoint to insert a link to a page, list item, or documents started receiving an error on the system...

on8 Dec 2018
Wiki Page: SharePoint Upgrade: Simple OOTB Inventory Methods Useful for Resolving Missing Dependencies

Stephan Bren

The following are simple OOTB inventory methods that I use when resolving missing dependencies listed in the report generated by Test-SPContentDatabase. These reporting methods work for SharePoint 2010, 2013 and 2016 on-premises. No need for third-party tools, which just do the same thing, but insert...

on3 Dec 2018
Wiki Page: SharePoint Gateway: PowerApps and Flow

Peter Geelen

Table of Contents Description Requirements Installation Video Testing Building the workflow Video Things you need to know #1 #2 #3 #4 Helpful links Description Microsoft recently released the On-Premises gateway which will connect with your SharePoint 2013 and 2016 on-premises environment. This...

on18 Nov 2018
Wiki Page: Remove alerts from all SharePoint Sites

Peter Geelen

Table of Contents See Also Want to Remove alerts from all SharePoint web applications including each site collections and sub-sites? *Do not run in Production Environment. It should run on Development and Testing Environment only. Run below PowerShell script: foreach...

on18 Nov 2018
Wiki Page: Working/Crawling With Large Lists In SharePoint 2010 - List Throttling

Peter Geelen

Introduction In order to retrieve any information using the object model along with retrieving up to the number of items specified in the List query size threshold for auditors and administrators property, there is a property you need to set in your query object. The property is called QueryThrottleMode...

on18 Nov 2018
Wiki Page: Sharepoint: Update system properties using Server Object Model

Peter Geelen

Table of Contents App.Config List.csv Program.cs File This article discusses a useful SharePoint server object model code that will allows you to update system properties of a list Item (Created, Created By,Modified, Modified By). while migration from previous version of SharePoint to New Version...

on17 Nov 2018
Wiki Page: SharePoint 2010 Troubleshooting: The workbook cannot be opened

get2pallav

Problem Table of Contents Problem Troubleshooting Solution References Notes Production SharePoint 2010 farm. User base using Office 2016 documents. Excel Calculation Services started on WFE. Excel Services Application Web Service Application running. Deployed new web application...

on13 Oct 2018

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support options

More support

Not an IT pro?

Wiki Page: SharePoint 2010: Access Denied By Business Data Connectivity Error in Using External Content Type List

Wiki Page: SharePoint 2010: The Web Server at URL Does Not Appear

Wiki Page: Excel Document opens as Read-Only and unable to check in the documents

Wiki Page: SharePoint: "The storage space allocation page cannot be used for sites that do not have a storage quota defined"

Wiki Page: SharePoint 2010: PowerShell Script to List the documents checked out with version details in a Site Collection

Wiki Page: SharePoint 2010: a spreadsheet method for quickly resolving missing non-upgrade-blocking dependencies

Wiki Page: SharePoint 2010 Troubleshooting: July 2013 Windows Security Update Breaks SharePoint XSLT System Web Part Pages

Wiki Page: SharePoint Upgrade: Simple OOTB Inventory Methods Useful for Resolving Missing Dependencies

Wiki Page: SharePoint Gateway: PowerApps and Flow

Wiki Page: Remove alerts from all SharePoint Sites

Wiki Page: Working/Crawling With Large Lists In SharePoint 2010 - List Throttling

Wiki Page: Sharepoint: Update system properties using Server Object Model

Wiki Page: SharePoint 2010 Troubleshooting: The workbook cannot be opened