Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 problem with View

Author  Topic 

Mjolnir
Starting Member

12 Posts

Posted - 2010-06-08 : 16:01:30
hi,

A short history first, some months ago, a programmer from our team do a job coding in C# and creating stored procedures and Views. This man has left the company 3 months...

Today When I call to the help desk guy if he check his job we can see that he use encrypt in some views in the database and the .sql file has remove.

I will try to get the view code using some tools to recover the source, but this dont work, only delete the view. (Thanks a god I do a backup)

some one can help with this, how do I to recover a view hidden using the parameter "with encryption".

thanks.

Mjolnir
Starting Member

12 Posts

Posted - 2010-06-08 : 16:17:53
excuse me friends but I am very stressed with this I need to recover the source code for five Views.

I call the guy and he says me I dont know (very ethical actitude)
Go to Top of Page

Mjolnir
Starting Member

12 Posts

Posted - 2010-06-08 : 17:32:27
friend help I will be fired from my job, I have a wife and two kids my sql skills are basic I tested some tools:

DecryptSQL
SQL Object Decrypter 1.2
SQL Code Recovery

The tools dont work, please some one can help me.

I test some SP with name decrypt2k and this only delete the view and dont get the code.

please help, I test using the DAC using parameter -T7806 to start the service, use later the tool and dont work.
Go to Top of Page
   

- Advertisement -