SQL Server Decrypt Function

SQL users can easily see how to decrypt an encrypted SQL database and how easy it is to expose object content by creating a stored procedure and scripting its contents in Query Analyzer. A common way to achieve is by specifying WITH ENCRYPTION option inside the CREATE or ALTER statement for each object deployed.