View Issue Details

IDProjectCategoryView StatusLast Update
0002567CaseTalk ManagerSQL Serverpublic2020-06-30 10:47
ReporterBCP SoftwareAssigned ToBCP Software 
PrioritynormalSeveritytextReproducibilityN/A
Status closedResolutionno change required 
Product Version 
Target VersionFixed in Version 
Summary0002567: SQL Server Compatibility
DescriptionSQL Server databases need an upgrade of compatibility level if the SQL Server Software is upgraded.
TagsNo tags attached.
CaseTalk Editionunknown

Activities

BCP Software

BCP Software

2020-06-30 10:47

administrator   ~0001687

Upgrading to SQL Server 2017 the following needs to be done:

SELECT NAME, COMPATIBILITY_LEVEL
FROM sys.databases
WHERE NAME = 'CaseTalk'; -- it may be reported below 140..

ALTER DATABASE CaseTalk
SET COMPATIBILITY_LEVEL = 140;
BCP Software

BCP Software

2020-06-30 10:47

administrator   ~0001688

This doesn't require a software change, it's part of the database maintenance.

Issue History

Date Modified Username Field Change
2020-06-30 10:46 BCP Software New Issue
2020-06-30 10:46 BCP Software Status new => assigned
2020-06-30 10:46 BCP Software Assigned To => BCP Software
2020-06-30 10:47 BCP Software Note Added: 0001687
2020-06-30 10:47 BCP Software Status assigned => closed
2020-06-30 10:47 BCP Software Resolution open => no change required
2020-06-30 10:47 BCP Software Note Added: 0001688