Troubleshooting: Database ‘AED moble’ is already open and can only have one user at a time
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.”
Possible Reason:
There is a user still accessing the database.
Solution:
1)Run the following query to find out the SPID:
select d.name, d.dbid, spid, login_time, nt_domain, nt_username, loginame
from sysprocesses p inner join sysdatabases d on p.dbid = d.dbid
where d.name = ‘db_name’
- db_name = AED_moble
2) From my example, the SPID from the result is 54.
3) Then run the following query to kill SPID and set multi users.
kill 54
GO
exec sp_dboption 'AED_moble', 'single user', 'FALSE'
GO
OR
ALTER DATABASE AED_moble SET MULTI_USER WITH ROLLBACK IMMEDIATE
By: Michelle 220616, Lay Swan 220628, P220629
|
AutoCount Accounting 1.8 / 1.9
|
|
AutoCount Payroll
|
|
AutoCount POS
|
|
AutoCount On The Go
|
|
AutoCount Accounting Plug-In Documentations
|