Hi Carolyn,

I still can't get the deadlock to show up in the log. I added the new alert that you mentioned and I added the notify operator as well...

I double checked and the profile is enabled. The script to set the jobs to write to the event log worked (one of the dummy job now is set...

I set up the alerts on a test system and have database mail enabled with a valid profile (that I can send a test email from). I added the...

Hi Brian,

I used the certificate to decrypt the encrypted columns and since you can see the certificates in the sys table, I figured someone could easily decrypt the columns as...

I guess we can just encrypt the backups using password protection and encrypt the data using the certificates. 🙂

Brandie,

Thanks again for the additional info. Will definately keep these things in mind. I have already scripted out all of the jobs and stored them away. The server...

Thanks! Is there anything else that I should be aware of during the relocation?

MP