I know that is quite some time, but in case someone runs into this preoblem. Check this link https://social.msdn.microsoft.com/Forums/sqlserver/en-US/891f4fca-40ad-46db-984e-1360e0190da4/error-17827-failure-while-attempting-to-encrypt-a-password?forum=sqlsecurity in that link search for Amy Peng's answer.

Are you using Transactional Replication?

russk2t (7/16/2014)

---

Thanks for the reply. To eliminate any permissions issues I am running all accounts under my own personal domain admin account. All servers are in the same domain....

Which accounts are you using to run the SQL Services on each of the Servers?

It is very interesting what you are doing. If I understood, you are testing SCOM by generating alerts. I have been using SCOM for quite a while now and honestly...

Thank you for the answers.

Thanks Gail. I forgot to mention that the stored procedure is running with the same parameters all the time as the ones used by the T-SQL.

According to Jonathan Kehayias (http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/12/21/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali.aspx) the event you are trying to add was added in Denali. That may explain the error.

Did the link from DouglasH help?

You may want to start by uninstalling 2008 R2.

This may help http://www.sqlservercentral.com/Forums/Topic1234281-17-1.aspx.

I found Paul's blog: http://www.sqlskills.com/blogs/paul/how-can-a-log-backup-fail-but-a-full-backup-succeed/.

Thanks for sharing!

As Gail already said the only way will be Shrinking the database/file(s). Deleting tables by itself will not give back the space to the OS. You will probably see the...

I don't know if I understand your question properly. Are you asking if there is a way to see all the columns in a database?