Symptom
- You are trying to run the script run_update_index_stats.sql as per KBA 1757691 to perform update index statistics for all tables in the <SID> database.
- This generates the following errors:
Msg 102, Level 15, State 181:
Server 'SID', Line 2:
Incorrect syntax near 'go'.
Msg 102, Level 15, State 181:
Server 'SID', Line 5:
Incorrect syntax near 'go'.
Msg 102, Level 15, State 181:
Server 'SID', Line 9:
Incorrect syntax near 'go'.
Msg 102, Level 15, State 181:
Server 'SID', Line 24:
Incorrect syntax near 'go'.
Msg 102, Level 15, State 181:
Server 'SID', Line 26:
Incorrect syntax near 'go'.
Msg 102, Level 15, State 181:
Server 'SID', Line 33:
Incorrect syntax near 'go'.
Msg 134, Level 15, State 1:
Server 'SID', Line 35:
The variable name '@cmd' has already been declared. Variable names must be
unique within a query batch or stored procedure.
Msg 102, Level 15, State 181:
Server 'SID', Line 48:
Incorrect syntax near 'go'.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0 for Business Suite
Product
Keywords
dos2unix , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.
SAP Knowledge Base Article - Preview