Stored procedures in AspDotnetStorefront e-commerce cart are encrypted to avoid accidental modification. But what if we need to modify or just view the stored procedure then we need to decrypt those stored procedure.

Now question arises how to decrypt these stored procedure ?

Answer is we can’t decrypt but we can create these again without encryption for that purpose follow the procedure as given below:-

• Backup your database first.
• Drop all stored procedures from the database using sql server mgt studio.
• Open the Create AspDotNetStorefront Database.sql script.
• Select stored procedure block from the script.
• Find/Replace WITH ENCRYPTION with empty string.
• Execute the newly created script i.e. stored procedure block only

Now we have all stored procedures in simple format that is without encryption.