Due to a database-restore, collation has been changed. If I try to
alter database <xyz> collate <xyz>
I get an error, that no exclusive lock to database to fulfil this operation can be gotten. Since sql-server is part of a virtual-machine, I'm quite sure, that no*one* has any database-access at this time but me. I thing that one ore few processes prevent me altering the collation having access to db, but I can't determine which it could be. I've deactivated all possible services having something in common with the sql-server, but error stays the same. ( Running Processes: MSSMS and Report Server )
I know I have successfully changed collation on another db in the past - easyway - via contextmenu/properties/collation, but this also has no success.
Reading several articles of changing collation of each object by one via cursor operation is not what i want to do.
Any hints would be appreciated!