Hello I'm trying to change the owner of an active SQL 2014 DB using:
ALTER AUTHORIZATION ON DATABASE::[TargetDB] TO LoginNameOwner;
When I run it it seems to hang and notice causes Blocking so I cancel above statement.
While running above there are Sessions that are in the Suspended, Running, Runnable statuses.
Is it correct to say that you can't run this statement while it's in some other state than Sleeping?
Thanks in advance.