Hello, I am trying to transfer a database using Transfer Database Task, but I am getting an error relating to an encrypted object called p_SYS_GetQDNPassword: Error: The Execute method on the task returned error code 0x80131500 (The StoredProcedure '[dbo].[p_SYS_GetQDNPassword]' cannot be scripted as its data is not accessible.). The Execute method must succeed, and indicate the result using an "out" parameter. The SQL user credentials used to access the server is sysadmin, but is there anyway to prevent this error during DB Copy (with DB online) process (or may be ignore the encrypted objects)?

Looks you got issues with porting encrypted data, thus you need to un-encypt it 1st of allArthur My Blog