Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006
    Posts
    2

    Unanswered: Updating system tables

    How can I grant permission to update a system table? I have a corrupt system table. This is what I thought I needed to use. Also I am using Sybase 9.02
    Thank you in advanced, any help is appreciated.

    sp_configure 'allow updates to system tables', 1

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    Code:
    sp_configure 'allow update', 1
    is for ASE. You mention version 9.0.something, in which case it sounds like you are using SQL Anywhere, and that is likely to have a different syntax to achieve this (sorry, I don't know what it is - but I'm sure that the manuals are available at http://sybooks.sybase.com and that they can provide the answer...)

    Michael

  3. #3
    Join Date
    Sep 2006
    Posts
    2
    Yes it is SQL Anywhere Studio 9.02...thanks for your help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •