Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

True or False Expand / Collapse
Author
Message
Posted Thursday, November 25, 2010 8:44 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, July 3, 2012 5:49 AM
Points: 418, Visits: 365
Comments posted to this topic are about the item True or False
Post #1026615
Posted Friday, November 26, 2010 12:48 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 1:20 AM
Points: 2,977, Visits: 896
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
Posted Friday, November 26, 2010 1:01 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:23 PM
Points: 13,189, Visits: 10,047
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
Posted Friday, November 26, 2010 2:07 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay 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
Posted Friday, November 26, 2010 2:15 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, June 30, 2014 2:31 AM
Points: 1,142, Visits: 765
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
Posted Friday, November 26, 2010 2:25 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, June 30, 2014 11:43 PM
Points: 1,399, Visits: 1,798
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
Posted Friday, November 26, 2010 3:05 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 8:43 AM
Points: 967, Visits: 1,244
Really Nice question.

Thanks
Post #1026705
Posted Friday, November 26, 2010 4:58 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, February 7, 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
Posted Friday, November 26, 2010 6:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 22, 2013 5:06 AM
Points: 10, Visits: 57
Good Question !!..


We can see the Execution Plan of Encrypted Procedure.
I have tested it..
Post #1026750
Posted Friday, November 26, 2010 8:51 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 5:21 PM
Points: 21,092, Visits: 14,766
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


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 »

Add to briefcase 123»»»

Permissions Expand / Collapse