I handled a phone call today from a client who claimed that when he restored
a database via Enterprise Manager, the owner of another database was reset
We created a new database (DB-B) that was to be the target of the restore
procedure. I verified that the db owner of the db in question was what it
should be. We used Enterprise Manager to restore the database from a file
that was originally a db on a different server. After the restore was
successful, we looked at a the database in question and the owner had been
changed to 'sa'!
Is it possible to have some procedure or 'trigger' (for lack of a better
term) that would run upon the Restore Event that could (maybe not the
intent) affect a different database? Would this procedure need to be
somewhere in the Master table?