Tag Info

New answers tagged


You could probably have just set the database owner to [sa] (or any valid login really) rather than detach / re-attach. ALTER AUTHORIZATION ON DATABASE::dbname TO [sa]; This probably happened because the login responsible for creating, attaching or restoring the database initially no longer exists. The UI isn't smart enough to fail gracefully when there ...

Top 50 recent answers are included