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 3 of 3

Thread: Edit Stored Procedures

  1. 10-22-2009, 01:04 AM #1
    adamroof is offline Junior Member
    Join Date
    Dec 2007
    Posts
    20

    Default Edit Stored Procedures

    Well, i was in the middle of upgrading to 8.0 from 7.1 and how do i now edit the stored procedures as they are locked/encrypted?

    I need to add the ManufacturerID to the aspdnsf_ProductInfo proc

    Adding -
    LEFT JOIN ProductManufacturer man WITH (NOLOCK) ON p.ProductID = man.ProductID

    We have bought the c# source code, is the SQL lock seperate?

    Thanks
  2. 10-22-2009, 01:36 AM #2
    ASPAlfred is offline Senior Member
    Join Date
    Nov 2007
    Posts
    2,244

    Default

    You'll have to open up the upgrade script that we provided to you in the build, and find that stored proc there at the bottom of it you can see 'WITH ENCRYPTION' remove it and re-run just the that stored proc against your DB to update.

    Make sure you made a backup first, just in case.
  3. 10-22-2009, 09:03 AM #3
    adamroof is offline Junior Member
    Join Date
    Dec 2007
    Posts
    20

    Default

    Thank you, i will try that.

    Is there any reason to leave WITH ENCRYPTION for any of the procs since we have the source code?