SYS_BACKUP server

[solrosfroet]

Hi,
new on sybase. I try to update the sysservers:
update sysservers set srvnetname='xxx_BS' where srvid=1 and it returns:

Ad-hoc updates to systems catalogs not enabled. A user with SSO role must reconfigure system to allow this.

Any help would be appreciated! Thanks.
gemma

[dshakey21]

you need to be an sa of the database with so role

then you need to enable config

sp_configure "allow updates",1

then run youe update

make sure to disable the config

sp_configure "allow updates",0

[Sneevarp]

this can be done by user having role "sso_role". You can check your roles by SP:

sp_helpuser