Thanks Jack!! According to BOL, the user credentials require an elevated access rights of one of the following:

1. DBO

2. sysadmin

3. db_securityadmin

When this user was configured with DBO access privilege,...

Hi Suresh,

The database at the destination is on SQL Server 2005 and it uses SQL encryption available with this edition of SQL Server. Accordingly, encryption can be done either AES...