on 05-31-2014 11:07 AM
Hi All,
I am trying to create the dump configuration as per the note 1588316 but i am getting the following error.
C:\Users\rfdadm>isql -Usapsa -SRFD -w300
Password:
1> use master
2> sp_config_dump @config_name='RFDDB',
3> @stripe_dir = '\\SAP-DEVL\sybase\RFD\backups' ,
4> @compression = '101' ,
5> @verify = 'header'
6> go
Msg 102, Level 15, State 181:
Server 'RFD', Line 2:
Incorrect syntax near 'sp_config_dump'.
Can any one please help me on this..??
Regards,
Letz..
First, a true statement that isn't quite the problem here:
When calling a stored procedure, if it isn't the only statement in the batch, you have to use an EXECUTE keyword before the procedure name.
Second, the "USE DATABASE" statement should be in a batch by itself. If you add a "GO" after "use master", ASE will stop complaining because the stored procedure then will be the only statement in its batch.
Combining both concepts:
use master
go
execute sp_config_dump
@config_name='RFDDB',
@stripe_dir = '\\SAP-DEVL\sybase\RFD\backups' ,
@compression = '101' ,
@verify = 'header'
go
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
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.