Reset List Item ID in SharePoint 2013 List

SELECT * FROM [WSS_Content].[dbo].[AllListsAux] where ListID='listGuid'

UPDATE [WSS_Content].dbo.AllListsAux set NextAvailableId=1 where ListID='listGuid'



Comments

Post a Comment

Popular posts from this blog

How to Create an Auto-Incrementing Number Field in a SharePoint List

Auto-numbering is a common requirement when working with SharePoint lists. You may want an auto-incrementing number on Issues list items such as “ISS-001” and so on. If you try using calculated column with ID field and entered a formula such as = (“ISS-00” & [ID]), this won’t work for new items! The reason being ID field is filled ONLY after the item is created. Here are the steps to create an auto-incrementing number field in a SharePoint list designer workflow: Create a new column, such as :  Increment Number  in issue list with Number type. Make this column hidden in a view. Create another column, such as :  Issue No.  in issue list with Formula type and add the following formula = “ISS-00” & [ Increment Number ]. This Column will show the increment items’ numbers in the list. Open SharePoint designer, create new list workflow (for issues list). Add a workflow action: “Update list Item” >> Current Item >> Add >> Set thi...
Read more

SharePoint Integration with IIS

Image
Before discussing the Integration, we will discuss the architecture of SharePoint at the architecture level. The diagram represents the architecture of SharePoint and split into two halves. The Left-half is administrator world and the right-half is the end-user world. Everything in right half resides in SharePoint content database. Let's continue with some terminologies before goes into deep dive.  Farm A farm is a logical architecture or logical grouping of SharePoint servers that share common resources of SharePoint. It can be a single machine or more than one machine. The farm is differentiated on their tier levels. Might be possible Farm can be 1to N-tier. Installation can either be done at 1 machine to N. Most of the cases in production you have to choose at least 5-tier architecture for application Server, front-end  Server , SQL, AD+DNS, Office Web App Server and Exchange; you can add more than one application server, Front-End etc at any level. C...
Read more

install the Windows Server Roles and features for SharePoint Server 2016 (.PS)

Log in to the Target SharePoint Application Server and Right clicking on Windows PowerShell will allow you run as "administrator". Then paste the below script there and execute it by pressing Enter. This Script will install the Windows Server Roles and features for SharePoint Server 2016. It might need a restart of the server during the installation. Make Sure You Have Inserted the Windows Server media and provide that path end of this Script for the SXS Folder. Import-Module ServerManager Add-WindowsFeature Net-Framework-Features,Web-Server,Web-WebServer,Web-Common-Http,Web-Static- Content,Web-Default-Doc,Web-Dir-Browsing,Web-Http-Errors,Web-App-Dev,Web-Asp-Net,Web-Net-Ext,Web- ISAPI-Ext,Web-ISAPI-Filter,Web-Health,Web-Http-Logging,Web-Log-Libraries,Web-Request-Monitor,Web-Http- Tracing,Web-Security,Web-Basic-Auth,Web-Windows-Auth,Web-Filtering,Web-Digest-Auth,Web-Performance,Web- Stat-Compression,Web-Dyn-Compression,Web-Mgmt-Tools,Web-Mgmt-Console,Web-Mgmt...
Read more