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--
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar