Sybase Ad-hoc updates to system catalogs not enabled

I have received this when tried to bcp in of the system table ‘sysusers’ in Sybase.

Server Message: LOCALHOST - Msg 10321, Level 14, State 1: Ad-hoc updates to system catalogs not enabled. A user with System Security Officer (SSO) role must reconfigure system to allow this. CTLIB Message: - L1/O3/S0/N14/0/0: blk_init(): blk layer: CT library error: Failed when CT_Lib routine ct_results() called. blk_init failed. bcp copy in failed

Reason:
This occurs when you try to directly modify an Adaptive Server system table without first using sp_configure to set the allow updates configuration parameter.

Solution:

1. As “sa,” use sp_configure to allow changes to the system catalog

sp_configure "allow updates", 1 go

2. make the changes and use sp_configure to disallow subsequent changes to the system catalog. Which is the default setting.

sp_configure "allow updates", 0 go

Leave a Reply

Your email address will not be published. Required fields are marked *