Changing database state from LOADING to OPERATIONAL

I found this solution:
www.novicksoftware.com/TipsAndTricks/
tip-sql-server-restore-database-with-recovery.htm
but haven't try it myself.

My own experience is to detach and re-attach the database.