SQLSACT (7/9/2013)

---

shohelr2003 (7/9/2013)

---

Thanks for...

If it was recent enough you might be able to get it from the standard report of schema changes for the database. But there are no guarantees.

CEWII

winston Smith (7/5/2013)

---

I appreciate it might not be the best solution from your point of view, but forgetting if its good or bad, is the only way to assign a...

The one's that are essentially log shipped are going to be tougher, because you can't modify the database target in any way. The ones that are mirrored are somewhat...

winston Smith (7/5/2013)

---

We have a package with sensitive data so encryptWithUserKey, and then run in the SQL Agent using a proxy is the best option.

But, we want to use a...

Without having some way of knowing the previous status there is no query that can accomplish this.

If you add a trigger or modify the update logic to write either a...

Fair enough, even when I worked in banking this wasn't required, but alright..

Based on that article the agent to the back end is encrypted or at least can be....

No problem.. Dupe Post, please reply to: http://www.sqlservercentral.com/Forums/Topic1469748-391-1.aspx

CEWII

The item that I find is this:

http://www.symantec.com/connect/blogs/backup-exec-2012-security-improvements

However, I am unaware of anywhere that the law requires this, where are you?

CEWII

Then...

As I read your post the AD domain is not being replaced but upgraded. I think that should be fairly painless, nothing that I can think of that should...

So short answer is there is no really good way to support what you are wanting to do..

CEWII

Be sure to run the setup program as an admin, got burned on that before.. My user has admin but it seemed to have problems so when I ran...

Using Database Mail there is no way for SQL to directly receive email and SSIS does not inherently have the ability to check for email. So without some external...

Thanks for the update.

CEWII