Error "Incorrect syntax near 'PIVOT'" when adding a Data Source to a test container, test folder or test
To resolve this issue you need to set the compatibility level of your SQL Server database to match the version that you are using.
Firstly to check the compatibility level that your database is currently using, execute the following SQL statement on your database server:
SELECT COMPATIBILITY_LEVEL FROM sys.databases WHERE name ='database_name'
To set the compatibility level you should execute the following SQL statement against your SilkCentral Test Manager database:
ALTER DATABASE database_name
SET COMPATIBILITY_LEVEL = level
database_name = name of your SilkCentral Test Manager database.
level = the version of SQL Server with which the database is to be made compatible. The value must be one of the following:
90 = SQL Server 2005
100 = SQL Server 2008 and SQL Server 2008 R2
110 = SQL Server 2012
There are further details on this at the following link: