Version: 15.0.9-5
Build #: 40634
Build Date: 2014-Oct-16 05:39:06 PM
Operating Environment: Mac OS X (10.8.5, x86_64) / UTF-8 / en / US / Oracle Corporation 1.7.0_60-b19
Memory: Max=3,819,962,368; Total=989,331,456; Free=530,789,952; CPUs=8
Object search : SQL Server 2000 gives exception if Source Search-> Trigger Source is enabled
1. Navigate to SQL Server 2000 and take Tools -> Object Search
2. Enable Source Search and tick Trigger Source
3. Hit the Search Button and you get an exception as below:
We made a change in the SQL for v14 to include sys.triggers which needs to be corrected for SQL Server 2000
net.sourceforge.jtds.jdbc.AQSQLException: Invalid object name 'sys.triggers'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:375)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2984)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2331)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:653)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1160)
at \\...\\ .\\हिñçêČάй語简�?한\\.sꋩꁖꐶꂠ.execute(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.cꏑꂨꅳᛌ short.c(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.I⡯ꅃꅖᠦ finally package.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.Nꇕꂥ⣟ꇡ super$2.process(Unknown Source)
at com.common.ui.util.BackgroundThread.run(Unknown Source)
The systriggers catalog table was not provided until version 2005 and is only used to extract the database level trigger. It will no longer be called unless version 2005 or above.