Invalid Object Name 'cmsPreviewXml'. error when publishing content in Umbraco

If you are getting the error message below when attempting to publish an item in Umbraco it will be because you do not have the table called "cmsPreviewXml" in your database. This is usually because of a recent upgrade not being fully completed.

To rectify this error, use the the Microsoft Sql Server script below to re-create the "cmsPreviewXml" table.

Microsoft SQL Server Script to re-create the "cmsPreviewXml" table:

Remember to replace "YOUR_DATABASE_NAME" with the name of the database that you want this table to reside in.

USE [YOUR_DATABASE_NAME]
SET QUOTED_IDENTIFIER ON;
CREATE TABLE [dbo].[cmsPreviewXml]( [nodeId] [int] NOT NULL, [versionId] [uniqueidentifier] NOT NULL, [timestamp] [datetime] NOT NULL, [xml] [ntext] NOT NULL, CONSTRAINT [PK_cmsContentPreviewXml] PRIMARY KEY CLUSTERED ( [nodeId] ASC, [versionId] ASC)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO