Solved

show object encrypted

Posted on 2010-08-12
7
305 Views
Last Modified: 2012-05-10
Hi experts, I have some encrypted views and stored procedures in my database, is there any way to extract only the encrypted objects
0
Comment
Question by:enrique_aeo
7 Comments
 
LVL 6

Expert Comment

by:Ashok Kumar
ID: 33428011
Lots of tools available as freeware.
SQLDecryptor is the one of the tool which avail as trial version.
0
 

Author Comment

by:enrique_aeo
ID: 33431525
and can not be done with transact sql code, using some system view
0
 
LVL 19

Expert Comment

by:Rimvis
ID: 33443768
Check this:Decrypting SQL Server database objectshttp://www.mssqltips.com/tip.asp?tip=1046
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 12

Expert Comment

by:pastorchris
ID: 33443960
Hi Enrique,
What do you mean by "extracting" encrypted views & stored brocs?
Do you want to get to move these excrypted objects from one database to another or you want to see the object text or body (comments) from syscomments?

Regards,
Chris Musasizi
0
 

Author Comment

by:enrique_aeo
ID: 33447054
I just need to see a list of encrypted objects
0
 
LVL 19

Accepted Solution

by:
Rimvis earned 250 total points
ID: 33451743
Is this what you want?

SELECT DISTINCT o.NAME, o.type FROM syscomments AS c INNER JOIN sys.objects AS o ON c.id = o.OBJECT_ID WHERE c.encrypted = 1
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

822 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question