Symptom
An error occurs in transaction DB02 (or transaction DBACOCKPIT) when entering screen Space -> Largest Tables
C Fri Mar 10 06:18:23:283 2023
C ERROR: -1 in function StartSelect (execute) [line 17738]
C (102) [42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'HINT'.
C Error 99 (dbcode 102) in StartSelect
C StartSelect: stmt of NULL_STMTID
C -- sap_get_top_tables RAT procedure to deliver the top largest or top
C -- most modified tables, in one or all schemas.
C -- Replaces sap_get_top_n_tables.
C
C declare @number int
C declare @order nvarchar(1)
C declare @schema_name sysname
C declare @db_name sysname
....
C set @cmd = @cmd +#
C N'OPTION (USE HINT (''FORCE_LEGACY_CARDINALITY_ESTIMATION''));'#
C set @cmd = @cmd + N' /*sap_get_top_tables*
Read more...
Environment
SAP Netweaver
Keywords
Incorrect syntax near 'HINT' dbcode 102 sap_get_top_tables FORCE_LEGACY_CARDINALITY_ESTIMATION , KBA , BC-DB-MSS-CCM , CCMS/Database Monitors for SQL Server , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.