1. Create a backup of your database before starting the database upgrade.

2. Run the following query in the database:

GRANT EXECUTE ON sp_get_old_texts TO Platform AS dbo
GRANT EXECUTE ON sp_deleteTextsAndMoveToPurge TO Web AS dbo
GO

IF NOT EXISTS (
  SELECT * 
  FROM   sys.columns 
  WHERE  object_id = OBJECT_ID(N'[dbo].[webServiceParams]') 
         AND name = 'EmailHeaderInformation'
)
BEGIN
ALTER TABLE [dbo].[webServiceParams] ADD EmailHeaderInformation bit NOT NULL Default(1)
END

          
GO

BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.CallRecognizer ADD
	WRITE_UNFOUND_EVENTS bit NOT NULL CONSTRAINT DF_CallRecognizer_WRITE_UNFOUND_EVENTS DEFAULT 1
GO
ALTER TABLE dbo.CallRecognizer SET (LOCK_ESCALATION = TABLE)
GO
COMMIT

          
GO

IF NOT EXISTS (
  SELECT *
  FROM   sys.columns
  WHERE  object_id = OBJECT_ID(N'[dbo].[webServiceParams]')
         AND name = 'CallListSelectionOrder'
)
BEGIN
ALTER TABLE [dbo].[webServiceParams] ADD CallListSelectionOrder INT NOT NULL Default(0)
END
          
GO

 IF NOT EXISTS (
  SELECT *
  FROM   sys.columns
  WHERE  object_id = OBJECT_ID(N'[dbo].[webServiceParams]')
         AND name = 'LimitExportSize'
)
BEGIN
ALTER TABLE [dbo].[webServiceParams] ADD LimitExportSize BigInt Default(NULL)
END
GO
UPDATE [dbo].[webServiceParams] SET LimitExportSize= 250  
GO

update dbo.versionTbl set version= '8.5.7184' where resource in ('SM', 'SMART')
go 


3. Run the following query to re-index the text data in the database:

exec dbo.sp_reindexTextDataByParams 1,0,0,''