To decrypt your 'encrypted' SPs and views, google 'sql server decrypt stored procedure' and take your pick.
You might want to challenge why the daatbase objects are encrypted. It offers next to no protection over finding out what the source text is. Its main function seems to be to make database maintenance operations more complex than they need to be.
You may also want to challenge why the target system needs to be SQL 2008, and get a justification why it cannot be upgraded to SQL 2008 R2 to match the source system. All the extra work you are having to do is costing your organisation, and a good way to eliminate these costs is to get the SQL versions matching.
Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 14 Mar 2017
: now over 40,000 downloads.Disclaimer: All information provided is a personal opinion that may not match reality.Quote: When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist. - Archbishop Hélder Câmara