Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 5 of 5

Thread: Access to Stored Procedures

  1. 08-18-2009, 05:31 PM #1
    jeskey is offline Junior Member
    Join Date
    Oct 2006
    Posts
    25

    Default Access to Stored Procedures

    I updated to SQL Express 2008 from SQL 2005 to do my SQL work. The Management Studio will not let me view or modify the stored procedures. "Modify" is grayed out. Visual Studio is the same. This is a local DB.

    I do not have this problem with the other databases (master, model,...). It seems like it could be a permissions issue. I am logging on as sa, also tried Windows auth.

    Does anybody who knows more about SQL than me (that would be a lot of people) have an idea where to start?
  2. 08-19-2009, 12:15 AM #2
    ASPAlfred is offline Senior Member
    Join Date
    Nov 2007
    Posts
    2,244

    Default

    Did you see a padlock icon on those stored procedures you can't edit/modify? See this thread - http://forums.aspdotnetstorefront.co...ight=encrypted
  3. 08-19-2009, 06:12 AM #3
    jeskey is offline Junior Member
    Join Date
    Oct 2006
    Posts
    25

    Default

    Thanks for your help. That is the problem.
  4. 09-11-2009, 04:45 AM #4
    amanukian@gmail.com is offline Member
    Join Date
    Mar 2008
    Posts
    45

    Default stored procs re-encrypt?

    Thanks for the tip. We need access to stored procs for customization. Do I need to re-encrypt stored procedures after customizations are coded?

    Thanks
    RMan
  5. 09-11-2009, 08:17 AM #5
    George the Great is offline Senior Member
    Join Date
    Nov 2006
    Location
    Cleveland, OH
    Posts
    1,792

    Default

    Nope...they will function the same either way
    <a href="http://www.aspdotnetstorefront.com">Shopping Cart Software</a>