• Foreign Key Constraint Issue on Inserts
    Description When making updates to Episerver you get an error "The INSERT statement conflicted with the FOREIGN KEY constraint". Resolution This is generally caused by either multiple web sites or multiple web environments (development, staging, integration, production, ...

  • How to Determine your Episerver Database Version
    In certain circumstances, such as a deployment, you may want to verify that you have the correct Episerver database version for your CMS package. Here are the steps for that. Resolution 1) Run the following stored procedure. declare @ver intexec @ver=sp_DatabaseVersionprint @ver...

  • Empty Recycle Bin - Episerver 6
    If you run into an issue with the recycle bin not emptying in Episerver 6 this query may help. Resolution Please only run this if you have exhausted all other options Run the following query against the database -EXEC editDeleteChilds @PageID =2 @ForceDelete = 1) //where 2 is ...

  • Determining largest tables within a database
    DescriptionAt times Support may ask for verification on the largest tables in a database either when investigating a performance issue or when investigating various functionalities of a site. The below steps detail how to verify what tables are taking up the most amount of space wihtin a databas...

  • A network-related or instance-specific error occurred while establishing a connection to SQL Server on EPIServer installation
    When installing an installation of EPIServer on a local machine the following error message is thrown by the site on compilation. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify t...