Troubleshooting: Database ‘AED moble’ is already open and can only have one user at a time: Revision history

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

29 June 2022

  • curprev 09:2709:27, 29 June 2022LaySwan talk contribs 993 bytes +993 Created page with "'''Question:''' When I try setting database to multi users, system prompted message “Database ‘AED_moble’ is already open and can only have one user at a time.” File:Set multiuser error1.png <u><b>Possible Reason:</b></u> There is a user still accessing the database. <u><b>Solution:</b></u> 1)Run the following query to find out the SPID:<br/> select d.name, d.dbid, spid, login_time, nt_domain, nt_username, loginame from sysprocesses p inner join sysda..."