Tag: SharePoint 2019
-
When using the PowerShell command Mount-SPContentDatabase or adding content database through the Central Admin you will receive this error message: The SELECT permission was denied on the object ‘sysobjects’, database ‘mssqlsystemresource’, schema ‘sys’. if the SharePoint Admin account has the deny permissions checked. The easy fix was to open SQL Server Management Studio and modify the…
-
Here is how to set column validation formula for SharePoint field to contain only numbers and only two symbols (fixed length). You have to use a “single line of text” field because the number field won’t work this way. Here is the formula: =IF(LEN(CustomSortOrder)=2,ISNUMBER(CustomSortOrder+0),FALSE) This works for both SharePoint 2010 and 2013 and can be…