@gscot81 - Great work with clarity and complete details.

Thanks! I used this view and it helps 🙂

i do have simillar problem.

DBCC DBREINDEX(MSreplication_subscriptions) helps me to resolve it immidiately.

Excellent Article. Thanks

What additional steps require if there is cluster environment? on primary node it works perfectly but when i failover the sql on secondary node , encrypted database...

I am able to fix this following error..

"For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and...

I had the same issue. I wait two days and waiting to clear the killed/rollback process by itself. I am end up with restart the SQL service and it clears.

Sandip

To prevents the user from seeing the databases in SQL SSMS try following command

DENY VIEW ANY DATABASE TO <UserName>

User still have access the database thru application but he cant see...

I had same problem..how you resolve the issue??