This Blog Has Been Moved !

This Blog Has been moved to http://aleemkhan.wordpress.com

SQL Server stored procedures can be encrypted when they are shipped as part of a product. To Encrypt the SQL Server Stored Procedures so they cannot be read by anyone/client/developer/dbo, use the WITH ENCRYPTION with the procedure definition. Consider for example

 

CREATE PROCEDURE CustomerSample WITH ENCRYPTION

AS

 

PRINT ‘This is an Encrypted Procedure’

 

GO

 

I am looking forward to writing and Debugging Stored Procedures using the Visual Studio 2005.

Comments

3 comments have been posted.
Posted @ 9:49 AM
Nice one Aleem, your blogs do get read by me frequently.

Haroon
 

Posted @ 11:33 AM
Aleem the link to your Resume is not working fine and the link to Brad Abram's Blogs is wrongly hyperlinked. Kindly if you find some time please correct them.

Haroon
 

Anonymous Anonymous
Posted @ 3:07 AM
The With Encryption is worthless. There are many applications that have the ability to decrypt objects. If you know of some other method, please let me know.