After upgrading to SilkCentral Test Manager 2009 (or above) the error “java.sql.SQLEXCEPTION: Incorrect syntax near the keyword 'WITH'” occurs when accessing the Test Plan’s ‘Grid View’ or while viewing the Activities page.

java.sql.SQLException: Incorrect syntax near the keyword 'WITH'.
 at com.segue.tm.frontendserver.ui.planning.PlanningGridDataStore.getData(PlanningGridDataStore.java:164)
 at com.borland.bca.webgui.ui.components.extjs.Grid$1.requestPerformed(Grid.java:150)
 at com.borland.bca.webgui.internal.html.internal.RequestDispatcher.invokeRequestListenersOfComponent(RequestDispatcher.java:121)
 at com.segue.scc.webgui.component.HtmlServletPage.dispatchRequest(HtmlServletPage.java:529)
 at com.segue.scc.webgui.component.HtmlServletPage.display(HtmlServletPage.java:629)

As of SilkCentral Test Manager 2009 there is no longer support for Microsoft SQL Server 2000 ( see release notes section “Technology Updates” at  http://techpubs.borland.com/silk_gauntlet/silkcentral_test_manager/2009/en/relnotes.htm )

A supported database (per the release notes ) must be used.

Microsoft SQL Server 2005 SP2
Microsoft SQL Server 2008
Oracle 9i (version 9.2.0.8 or later)
Oracle 10g (version 10.2.0.3)