How to encrypt stored procedure in SQL Server 2005?

Looking around for how to encrypt stored procedure in Sql Server 2015, you are at the right place. At times, we need to encrypt the text of stored procedures as the SPs might contain sensitive or confidential data/information. So Sql Server provides WITH ENCRYPTION to encrypt the Stored Procedure.

CREATE procedure [dbo].[ImplementEncryption]

SELECT top 1 name, designation
from Employee
Order by employeeid

Once we encrypt stored procedure by using WITH ENCRYPTION, we wont be able to view the stored procedure . Any attempt to view the stored procedure returns a message specifying that the text in stored procedure is encrypted:

EXEC sp_helptext ImplementEncryption
The text for object ‘ImplementEncryption’ is encrypted.

One important point to note is: Save the original text of the stored procedure before encrypting it, as there is no straightforward way to decode the encrypted text.

SQL professionals agree that the default stored procedure encryption that comes with MSSQL 2005, 2000 and 7.0 is ineffective and easily broken. In fact, Google generates over 3700 links for a search phrase “SQL decryptor”, offering dozens of software solutions that can bypass MSSQL “native” encryption. It is weak not necessarily because the encryption is weak (it uses RC4), but because the encryption key can be easily found. An attacker will focus on finding the encryption key rather than breaking the encryption algorithm in such a solution. This is a general problem and for any solution you consider, you should look at how easy it is for someone to find the encryption key.

One other way to see the text in encrypted stored procedure is to attach a debugger to the server process. Then we can retrieve the decrypted procedure from memory at runtime.

Which version of JavaScript is supported by my browser?

JavaScript is a must for almost all the web applications. And like other programming languages, JavaScript’s many version are available. The commnads you used in coding will only be supported on browser support the version(or higher versions) when the corresponding commands were introduced. So many times we programmers, come across situations when our application’s javascript works fine on one machine but not on other. In such cases, we should first check the versions supported and write the code accordingly.Otherwise, the command not supported on some machines can even crash the application.

We can determine the javascript version supported by browser by using HTML along with JavaScript. To achieve this, follow the steps:

1. Open a notepad file, and paste this code in it.

<script type=”text/javascript”>

var myver= 1.0;


<script language=”Javascript1.1″>

myver = 1.1;


<script language=”Javascript1.2″>

myver = 1.2;


<script language=”Javascript1.3″>

myver = 1.3;


<script language=”Javascript1.4″>

myver = 1.4;


<script language=”Javascript1.5″>

myver = 1.5;


<script language=”Javascript1.6″>

myver = 1.6;


<script language=”Javascript1.7″>

myver = 1.7;


<script language=”Javascript1.8″>

myver = 1.8;


<script language=”Javascript1.8.1″>

myver = 1.8.1;


<script language=”Javascript1.8.2″>

myver = 1.8.2;


<script language=”Javascript1.8.5″>

myver = 1.8.5;

<script type=”text/javascript”>

document.write(‘<p><b>Javascript version ‘ + myver + ‘ supported<\/b><\/p>’);


2. Save this file as .html(e.g. version.html)

3. Now open this file with the browser on which you want to know the JavaScript version supported