Tuesday, 10 March 2015

ALTER AUTHORIZATION

(For my own reference)

To resolve this issue in Microsoft SQL Server (often observed when you restore a database that came from another server):

SQL Server Management Studio information dialog

Run this:

alter authorization on database::[MyDbName] to sa;