Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    15

    Angry Unanswered: HELP with SP_configure

    I am running the following command:

    exec sp_configure 'allow updates', '0'

    I get:

    Server: Msg 15247, Level 16, State 1, Procedure sp_configure, Line 169
    User does not have permission to perform this action.

    What's causeing this?

    Thanks!

    Ken

  2. #2
    Join Date
    Sep 2003
    Posts
    522
    you need to be associated (at least) with serveradmin role to be able to perform this operation. check with your sql server dba on that.

Posting Permissions

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