Hi, I'm having a problem.

I've created an encrypted view, as the sql to create the view contained usernames and passwords.

Now although the SQL was correct, there is something stopping the view from working. We think its that the username and pasword used, dont have permission to access what the view was trying to link to, which was also happens to be another encrpyted view.



My problem is since the view doesnt work and is enctypted, i cant change it,alter it or drop it with out it crashing enterprise manager.

Does anyone know how to delete a currupt encypted view.
or remove the encryption, i'm guesing you cant because that would defeat the purpose on encryption.

thanks for anyhelp

If you have full rights to the database you can use the following code to DECRYPT your view.

http://www.planet-source-code.com/vb...d=505&lngWId=5