Wrox Programmer Forums
|
BOOK: Beginning Database Design
This is the forum to discuss the Wrox book Beginning Database Design by Gavin Powell; ISBN: 9780764574900
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Database Design section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 13th, 2009, 04:06 AM
Friend of Wrox
 
Join Date: Nov 2009
Posts: 156
Thanks: 13
Thanked 16 Times in 16 Posts
Default encryption

how can i view source of encrypted stored procedure

to view a stored procedure's code you can use this statement

exec sp_helptext someSP

if you declare a stored procedure like this:

create proc pMySp
(
@testParameter nvarchar(50)
)
with encryption
as
select @testParameter



when you use 'exec sp_helptext pMySp' you will get a message that 'pMySp' is encrypted

no how can i view source of encrypted sp?





Similar Threads
Thread Thread Starter Forum Replies Last Post
Encryption timeware SQL Server 2005 1 September 7th, 2006 12:35 PM
FTP and encryption GeorgeW SQL Server DTS 0 June 9th, 2006 09:24 AM
Encryption mani_he Pro PHP 3 October 18th, 2005 02:20 PM
Md5 encryption rahuljain_w .NET Web Services 2 September 30th, 2005 05:03 AM
with encryption jtrifts SQL Server 2000 1 February 21st, 2005 12:49 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.