on 04-29-2014 10:28 AM
Hi,
I try to run update statics in my DB system.
I did that with note 1757691 - SYB: How to manually update index statistics of a table using isql.
But after successfully run the programe its show bellow error. The sql also attached. Please help.
Msg 102, Level 15, State 181:
Server 'DEV', Line 2:
Incorrect syntax near 'go'.
Msg 102, Level 15, State 181:
Server 'DEV', Line 5:
Incorrect syntax near 'go'.
Msg 102, Level 15, State 181:
Server 'DEV', Line 9:
Incorrect syntax near 'go'.
Msg 102, Level 15, State 181:
Server 'DEV', Line 24:
Incorrect syntax near 'go'.
Msg 102, Level 15, State 181:
Server 'DEV', Line 26:
Incorrect syntax near 'go'.
Msg 102, Level 15, State 181:
Server 'DEV', Line 33:
Incorrect syntax near 'go'.
Msg 134, Level 15, State 1:
Server 'DEV', 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 'DEV', Line 48:
Incorrect syntax near 'go'.
[10] %
Hi
You can use the transaction code DBACOCKPIT and then update the statistics, Kindly refer the SAP link
Regards
Sriram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.