Msg 15247, Level 16, State 1, Line 1

Discussion in 'Databases' started by MKLAUSMEYER, Feb 27, 2009.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Help please


    Using sql server management studio express


    I am using this query command-


    ALTER DATABASE SQL2005_******_********_user SET TRUSTWORTHY ON


    I get this message-


    Msg 15247, Level 16, State 1, Line 1


    User does not have permission to perform this action.


    What all do I have to do to to get permission?


    Thank you in advance.
     
  2. JorgeR

    JorgeR DiscountASP.NET Staff

    To set this option, you must be a member of the sysadmin fixed server role.


    junior

    DiscountASP.NET

    www.DiscountASP.NET
     
  3. Junior


    Thank you for the help but I need to know how to get past this problem in order to add a stored procedure to my database.
     
  4. Bruce

    Bruce DiscountASP.NET Staff

  5. JorgeR

    JorgeR DiscountASP.NET Staff

    Unfortunately we will not be able to enable this setting nor you will be able to run CLR on our servers


    junior

    DiscountASP.NET

    www.DiscountASP.NET
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page