STORED PROCEDURE WITH ENCRYPTION

 

 STORED PROCEDURE  WITH ENCRYPTION

Use Northwind

select * from sys.tables

--Execution plan Does not Show up using Encryption Method.

--Execute query before Using  Ctrl +M (Execution plan)

CREATE PROC #Encryption

WITH ENCRYPTION

AS

SELECT * FROM Orders

EXEC #Encryption

-- View in Tempdb in stored Procedures  Temp Store proc [#Encryption,#EncryptionPlan]

Sp_helptext #Encryption --does not view

CREATE PROC #EncryptionPlan

AS

SELECT * FROM Orders

EXEC #EncryptionPlan

Sp_helptext #EncryptionPlan --does not view Sp name # (Symbol) using temporary Store procname

CREATE PROC P_model

AS

SELECT * FROM Orders

Sp_helptext P_model --view in text

/* Clean Up */

DROP PROCEDURE #Encryption

DROP PROCEDURE #EncryptionPlan

DROP PROCEDURE P_model

GO

 

 

 

 

Browse More Articles

Tweet

Written by Test

We are Creative Blogger Theme Wavers which provides user friendly, effective and easy to use themes. Each support has free and providing HD support screen casting.