cancel
Showing results for 
Search instead for 
Did you mean: 

incorrect syntax near sp_config_dump

Former Member
0 Kudos

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..

Accepted Solutions (1)

Accepted Solutions (1)

former_member188958
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Thanks a lot Bret...

Answers (0)