Minggu, 10 Oktober 2010

Encrypted Stored Procedure and Activity Monitor

I recently had received question if any stored procedure is encrypted can we see its definition in Activity Monitor.No.Let us do quick test. Let us create following Stored Procedure and then launch Activity Monitor and check the text. USE AdventureWorksGO-- Create Encyrpted SPCREATE PROCEDURE uspEncWITH ENCRYPTIONASSELECT *FROM Sales.SalesOrderDetailUNIONSELECT *FROM Sales.SalesOrderDetailGO--

Tidak ada komentar:

Posting Komentar