Troubleshooting: Database ‘AED moble’ is already open and can only have one user at a time: Difference between revisions
Troubleshooting: Database ‘AED moble’ is already open and can only have one user at a time (view source)
Revision as of 09:27, 29 June 2022
, 1 year agoCreated 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..."
(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...") |
(No difference)
|