<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Arup Chakraborty
»
True or False
21 posts, Page 1 of 3
1
2
3
»
»»
True or False
Rate Topic
Display Mode
Topic Options
Author
Message
arup chakraborty
arup chakraborty
Posted Thursday, November 25, 2010 8:44 PM
SSC-Addicted
Group: General Forum Members
Last Login: Tuesday, July 03, 2012 5:49 AM
Points: 418,
Visits: 365
Comments posted to this topic are about the item
True or False
Post #1026615
Rune Bivrin
Rune Bivrin
Posted Friday, November 26, 2010 12:48 AM
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 12:46 AM
Points: 2,655,
Visits: 717
Great question.
But the version should have been specified. In SQL 2000 you can see the execution plan even for encrypted procs. Although that would probably have been a dead giveaway of the correct answer
Just because you're right doesn't mean everybody else is wrong.
Post #1026660
Koen Verbeeck
Koen Verbeeck
Posted Friday, November 26, 2010 1:01 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 6:54 AM
Points: 9,364,
Visits: 6,462
Great question! You've got me thinking for a while. Definately learned something.
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1026666
Mayank Parmar
Mayank Parmar
Posted Friday, November 26, 2010 2:07 AM
Say Hey Kid
Group: General Forum Members
Last Login: Wednesday, September 21, 2011 4:03 AM
Points: 713,
Visits: 100
Hi,
I never created any encrypted stored procedure. So I just guessed, any my guessing was correct.
Regards,
Mayank Parmar
--------------------------------------------------------------------------------
Mayank Parmar
Software Engineer
Clarion Technologies
SEI CMMI Level 3 Company
8th Floor, 803, GNFC info Tower,
SG Highway, Ahmedabad - 380 054,
Gujarat, India.
www.clariontechnologies.co.in
Email: mayank.parmar@clariontechnologies.co.in
MSN : mayank.parmar@clariontechnologies.co.in
Mobile: +91 9727748789
--------------------------------------------------------------------------------
Post #1026687
sharath.chalamgari
sharath.chalamgari
Posted Friday, November 26, 2010 2:15 AM
Ten Centuries
Group: General Forum Members
Last Login: Monday, September 17, 2012 7:30 AM
Points: 1,038,
Visits: 679
Good Question, in our development we have only one Proc with encryption and i was doing some R&D on it, it helped me to answer this Question.
Post #1026689
Nakul Vachhrajani
Nakul Vachhrajani
Posted Friday, November 26, 2010 2:25 AM
Ten Centuries
Group: General Forum Members
Last Login: 2 days ago @ 9:52 AM
Points: 1,277,
Visits: 1,608
The question missed the version of SQL Server targetted, however, this behaviour is still confusing.
From books online:
However, the text will be available to privileged users that can either access system tables over the DAC port or directly access database files. Also, users that can attach a debugger to the server process can retrieve the decrypted procedure from memory at runtime. For more information about accessing system metadata, see Metadata Visibility Configuration.
(
http://msdn.microsoft.com/en-us/library/ms187926.aspx
)
Wouldn't we call viewing the execution plan a debugging exercise?
Thanks & Regards,
Nakul Vachhrajani.
http://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx
Be courteous. Drive responsibly.
Follow me on
Twitter:
@nakulv_sql
Google Plus:
+Nakul
Post #1026692
Hardy21
Hardy21
Posted Friday, November 26, 2010 3:05 AM
SSC Eights!
Group: General Forum Members
Last Login: Monday, May 13, 2013 2:42 PM
Points: 877,
Visits: 1,158
Really Nice question.
Thanks
Post #1026705
Phil Jackson
Phil Jackson
Posted Friday, November 26, 2010 4:58 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Thursday, February 07, 2013 5:12 AM
Points: 509,
Visits: 182
Good question!
Phil
Although all answers are replies, not all replies are answers.
Blog: http://philjax.wordpress.com
Post #1026739
igsri
igsri
Posted Friday, November 26, 2010 6:03 AM
Forum Newbie
Group: General Forum Members
Last Login: Friday, May 25, 2012 2:03 AM
Points: 9,
Visits: 55
Good Question !!..
We can see the Execution Plan of Encrypted Procedure.
I have tested it..
Post #1026750
SQLRNNR
SQLRNNR
Posted Friday, November 26, 2010 8:51 AM
SSCoach
Group: General Forum Members
Last Login: 2 days ago @ 1:46 PM
Points: 18,732,
Visits: 12,329
Nakul Vachhrajani (11/26/2010)
The question missed the version of SQL Server targetted, however, this behaviour is still confusing.
From books online:
However, the text will be available to privileged users that can either access system tables over the DAC port or directly access database files. Also, users that can attach a debugger to the server process can retrieve the decrypted procedure from memory at runtime. For more information about accessing system metadata, see Metadata Visibility Configuration.
(
http://msdn.microsoft.com/en-us/library/ms187926.aspx
)
Wouldn't we call viewing the execution plan a debugging exercise?
No. Not for the purposes of this question nor for the article referenced. I would call reading the execution plan a performance exercise.
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1026795
« Prev Topic
|
Next Topic »
21 posts, Page 1 of 3
1
2
3
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
