I have a DTS Package to Object Transfer stored procedures
with extended properties between two databases on
different servers. The security appears to be correct to
allow the transfer as the user has dbo rights on both
databases, but the package is failing with BACKUP LOG and
SETUSER permission denied messages.