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.