I worked for more than two weeks to backup / copy the database and script of my stored procedures from the SQL Server (2008) web server to the local installation (2008).
The problem is that I can not copy encrypted. I know that he completely defeats the goal of encryption in order to be able to receive the actual data, but I was interested ... In our case, the guy who developed the database disappeared 2 years ago and left everyone in the company without "open" - without encryption - backups of encrypted joint ventures. I am a "new" guy and cannot understand how to get to know these joint ventures.
Well, the message I get when I try to copy them using the script Wizard is a little obvious:
The TextHeader property is not available for StoredProcedure '[DBO]. [SP_CALC_PT_TV]. This property may not exist for this object or may not be restored due to insufficient access rights. The text is encrypted. (Microsoft.SqlServer.Smo)
I have tried so far, without success:
- access to them through Management Studio (the “change” option is grayed out and the scripts do not work)
- using the host provider’s own solution (Internet-based) to access the SPs
- using a third-party application to decrypt them (insufficient rights to run some commands)
Of course, I can just do it all again (about 45 SP) from scratch, but I had to guess what kind of content it was, and, you know ...
I would appreciate any help. Thank you in advance.
source share