What are the challenges you face when working across database platforms? Take the survey

SqlPrompt, a great way to view encrypted stored procedures

stevegsteveg Posts: 9
edited July 1, 2008 11:32AM in SQL Prompt Previous Versions
Did you know SqlPrompt is a great way to view encrypted stored procedures?

For instance, I am unable to use sp_helptext, syscomments or SqlServer Management Studio to view encrypted stored procedures, but if I hover using SqlPrompt I can see the procedure text.

It's not an area I know a great deal about (the only encrypted SPs I've got lying around are Microsoft CMS), but it seems odd SqlPrompt can be used like this.

I've found it very useful, just wondering if it's a feature or...


  • Options
    SQL Compare can only look at encrypted SQL 2000 databases. Unfortunately (or fortunately depending who you are) Microsoft tightened the encryption with SQL 2005, so I would imagine therefore you are looking at SQL 2000 stored procedures.
    Chris Buckingham
    Red-Gate support
Sign In or Register to comment.