Hi this is the first time that I've encounter this error in generating script for my database, what do you think causes this error? Thanks. Please see image.enter image description here

  • Is dbo.DisposeTemporaryTable encrypted? – Mark Sinkinson May 26 '15 at 6:24

You are getting the error as you are trying to script out OBJECT that is encrypted. You should read the error carefully as it is self descriptive :

enter image description here

There are ways that you can use as described in my answer - How to view an encrypted view or stored procedure ? and here - Martin's answer.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.