Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    21

    Unanswered: syslogs on master database

    Hi,
    As I understand the sp_dboption is not for master database

    1> sp_dboption master, "trunc log on chkpt" , true
    2> go
    Msg 17422, Level 16, State 1:
    Server 'DOLITTLE', Procedure 'sp_dboption', Line 217:
    The 'master' database's options can not be changed.
    (return status = 1)

    someone please confirm this.

    thks

  2. #2
    Join Date
    Jun 2003
    Posts
    140
    you cant change any options for master database

  3. #3
    Join Date
    Mar 2006
    Posts
    25

    Unhappy

    master database is system database which is created during installation of sybase server,so we cannot change any parameters of master database.


    Quote Originally Posted by dss
    Hi,
    As I understand the sp_dboption is not for master database

    1> sp_dboption master, "trunc log on chkpt" , true
    2> go
    Msg 17422, Level 16, State 1:
    Server 'DOLITTLE', Procedure 'sp_dboption', Line 217:
    The 'master' database's options can not be changed.
    (return status = 1)

    someone please confirm this.

    thks

Posting Permissions

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