How can I see the stored procedure in decrypt view SQL 2000?

Asked By torres peterson 0 points N/A Posted on - 12/18/2012

I am working in a multinational enterprise.

It uses Structured Query Language version (SQL) 2000.

My recent job is to write an interface to a large enterprise application.

So I badly need to check the stored procedure.

Can you please explain me How will I see the stored procedure in decrypt view SQL 2000?

• Status: Open
• Question Views: 1073
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Johnstoon Leen 0 points N/A #167211

How can I see the stored procedure in decrypt view SQL 2000?

Hi Torres Peterson,

There is a solution for your question.

Here is a stored procedure which will decrypt all stored procedures, triggers and views too and that were encrypted as using “with encryption”.

 

There are two versions 

One procedure for stored procedures only and another one for stored procedures, triggers and views.

 

Version One

Input: Object name (Stored procedure, View, Trigger)

 

Version Two

Input: Object name (Stored procedure, View, Trigger),

Object Type (‘P’-stored procedure, ‘T’-Trigger, ‘V’-View)

 

Here is the way to work with stored procedure.

 

 

 

I hope you’ll like this solution and make your way easy for you with this help. Good Luck!

 

Regards,

 

Johnstoon Leen

About Johnstoon Leen

Questions
4

Answers
102

Best Answers
64

• Vote Up 0 Vote Down

• Posted on - 01/21/2013
• Question Category: MySQL Server