> I would like drop and re.re-create the views, sp and functions encrypted.
> Is there any sp or function to do this?

"Erland Sommarskog" wrote:

> JCP (JCP@discussions.microsoft.com) writes:
> > I would like drop and re.re-create the views, sp and functions encrypted.
> > Is there any sp or function to do this?
>
> Beware that encryption is this context is not real encryption, only
> obfustication. Anyone who is dead set to retrieve your code will so so.
> If you want to protect your intellectual property, you need to get a license
> agreement.
>
> Since you consider doing this step, I assume that you have your code under
> version control. If you only keep your code in the database - which is very
> bad practice - and then change them to sau WITH ENCRYPTION, you will not
> be able to retrieve the code, with less than researching the methods to
> crack the obfustication that I discussed above.
>
> Also keep in mind that when your procedures are encrypted, you will
> experience a loss in functionality when using Profiler, and you will
> not be able to view execution plans (the latter applies to SQL 2005 only).
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx