Any idea how to resolve this error? seemingly a nightly process loads data into my joebloggs_DB database, its then copied from jobbloggs_DB database to LIVE DB. Issue is sometimes the process fails with the following error:
Error: Database 'JoeBloggs' is already open and can only have one user at a time.
It looks like the database JoBloggs is put into single user mode and then sometimes has difficulties taking it out of single user mode into multi user mode.
To resolve this issue manually in a live situation I would check and see what process has locked the DB and kill it.
WHERE resource_database_id = DB_ID('Joebloggs_DB')
However this is happening intermittently at night. Is there any way to ensure it does not occur?
thanks in advance