When I create a database, I have always changed the database owner from me (usually my domain account) to another, either a standard service account used for ownership, or to the usual sa
However, I've just inherited a series of instances where a lot of the databases have been created by another member of staff, who's now left, so naturally his domain account has been deleted.
Didn't run into any issues with this until yesterday when I tried to create a stored procedure on a database that would execute as owner (blindly believing it to be 'sa'). The create failed because the owner didn't exist, so I had no choice but to make an ad-hoc change as the client needed the stored procedure creating.
There are tons of production databases under his name so I want to be both pro-active and change-control savvy.
First question is, what are the potential issues this could cause now or in the future?
Second question, can I safely just change ownership to that of a standard account or 'sa'? Could it, will it, have any weird impact?