Professional Web Applications Themes

Alter system SPs - Microsoft SQL / MS SQL Server

Can anyone tell me why the default stored procedures in a database are sometimes of the Type 'User' and sometimes of the Type 'System'? We are required to encrypt ALL stored procedures and I cannot alter them to add 'with encryption' when they are of the type 'System'. Little help? Peter Cwik com...

  1. #1

    Default Alter system SPs

    Can anyone tell me why the default stored procedures in a
    database are sometimes of the Type 'User' and sometimes of
    the Type 'System'? We are required to encrypt ALL stored
    procedures and I cannot alter them to add 'with
    encryption' when they are of the type 'System'.

    Little help?
    Peter Cwik
    com
    'System' Guest

  2. #2

    Default Re: Alter system SPs

    Why would you want to encrypt a system SP seeing as every installation of
    SQL Server has them.?

    --


    Allan Mitchell (Microsoft SQL Server MVP)
    MCSE,MCDBA
    www.SQLDTS.com
    I support PASS - the definitive, global community
    for SQL Server professionals - http://www.sqlpass.org
    Allan Guest

  3. #3

    Default RE: Alter system SPs

    Hi Peter,

    Do not try to alter system stored procedures, I do not think this is
    supported.

    Sincerely,
    Yih-Yoon Lee [Microsoft]
    Microsoft SQL Server Support

    This posting is provided "AS IS" with no warranties, and confers no rights.
    Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

    Yih-Yoon Guest

  4. #4

    Default Re: Alter system SPs

    Ours is not to wonder why, ours is but to do and die...

    The government said so and thus it must be so. So the
    question remains...Why are they sometimes System and
    sometimes User? 
    installation of 
    Peter Guest

  5. #5

    Default RE: Alter system SPs

    Folks your missing the point. I'm asking if its a good
    idea, or if its supported. I'm asking WHY are the default
    stored procedures sometimes of the type System and
    sometimes of the Type User. That is the only question I
    need assistance with.
    Thanks,
    Peter Cwik 
    think this is 
    confers no rights. 
    http://msdn.microsoft.com/newsgroups. 
    Peter Guest

Similar Threads

  1. alter table alter column syntax problem
    By Chuck in forum MySQL
    Replies: 4
    Last Post: September 5th, 05:17 PM
  2. Replies: 6
    Last Post: November 22nd, 06:23 AM
  3. ALTER TABLE ALTER COLUMN
    By Jacco in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: August 7th, 05:59 PM
  4. The Alter...
    By Val in forum Photography
    Replies: 4
    Last Post: July 29th, 01:33 AM
  5. What *really* happens at ALTER TBSP END BKP ?
    By Tanel Poder in forum Oracle Server
    Replies: 8
    Last Post: July 8th, 09:57 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139