August 18, 2001 at 5:35 am
hello once again,
this time i have encrypted a view and when i open its design view the error comes as :
"query designer encountered an unexpected error cant open encrypted view "
but the data in the view is seen, now i want to modify the design view but its not working any ideas have tried book online help but nothing is striking
thanks in advance
keyur
August 18, 2001 at 8:17 am
You need to drop and recreate your view. Once you encrypt it SQL no longer stores the plain text of the view/proc/function in plain text. If you're using encryption you should probably look at using SourceSafe or other version control to keep plain text copies of your scripts.
Andy
December 8, 2002 at 4:32 pm
See recent posting in scripts area for a scripts to decrypt encrypted data base objects.
December 8, 2002 at 5:13 pm
There is the script posted here (based on shoeboy's original post to a security forum) and there's also dSQLSRVD, which you should be able to find via Google. The latter is a program that can decrypt, but it'll require sysadmin privs to do so.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply