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


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 3:07 AM
Points: 3,100, Visits: 984
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 @ 7:44 AM
Points: 13,562, Visits: 11,372
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: Tuesday, November 18, 2014 10:02 AM
Points: 1,194, Visits: 789
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


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, November 21, 2014 6:49 AM
Points: 1,451, Visits: 1,855
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://nakulvachhrajani.com
Be courteous. Drive responsibly.

Follow me on
Twitter: @sqltwins
Google Plus: +Nakul
Post #1026692
Posted Friday, November 26, 2010 3:05 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, November 20, 2014 5:13 AM
Points: 1,131, Visits: 1,394
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 9:21 AM
Points: 17,977, Visits: 15,981
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, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1026795
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse