22,209
社区成员
发帖
与我相关
我的任务
分享
EventType Parameters EventInfo
Language Event 0 ALTER DATABASE gpsdb SET MULTI_USER;
spid dbid ObjId IndId Type Resource Mode Status
51 4 0 0 DB S GRANT
53 7 0 0 DB S GRANT
54 8 0 0 DB S GRANT
55 8 0 0 DB S GRANT
56 8 0 0 DB S GRANT
57 7 0 0 DB S GRANT
57 7 0 0 DB X WAIT
58 7 0 0 DB S GRANT
58 7 0 0 DB X WAIT
59 8 0 0 DB S GRANT
61 8 0 0 DB S GRANT
62 8 0 0 DB S GRANT
64 1 1131151075 0 TAB IS GRANT
SPID Status Login HostName BlkBy DBName Command CPUTime DiskIO LastBatch ProgramName SPID REQUESTID
1 BACKGROUND sa . . NULL RESOURCE MONITOR 0 0 2017-8-31 00:15 1 0
2 BACKGROUND sa . . NULL RESOURCE MONITOR 0 0 2017-8-31 00:15 2 0
3 BACKGROUND sa . . NULL XE TIMER 0 0 2017-8-31 00:15 3 0
4 BACKGROUND sa . . NULL XE DISPATCHER 62 0 2017-8-31 00:15 4 0
5 BACKGROUND sa . . NULL LAZY WRITER 639 0 2017-8-31 00:15 5 0
6 BACKGROUND sa . . NULL LAZY WRITER 93 0 2017-8-31 00:15 6 0
7 BACKGROUND sa . . NULL LOG WRITER 2121 0 2017-8-31 00:15 7 0
8 BACKGROUND sa . . NULL LOCK MONITOR 15 0 2017-8-31 00:15 8 0
9 BACKGROUND sa . . master SIGNAL HANDLER 0 0 2017-8-31 00:15 9 0
10 sleeping sa . . master TASK MANAGER 0 0 2017-8-31 00:15 10 0
11 BACKGROUND sa . . master TRACE QUEUE TASK 31 0 2017-8-31 00:15 11 0
12 BACKGROUND sa . . master BRKR EVENT HNDLR 0 30 2017-8-31 00:15 12 0
13 BACKGROUND sa . . master BRKR TASK 0 0 2017-8-31 00:15 13 0
14 BACKGROUND sa . . tempdb CHECKPOINT 390 68 2017-8-31 00:15 14 0
15 BACKGROUND sa . . master TASK MANAGER 0 0 2017-8-31 00:15 15 0
16 sleeping sa . . master TASK MANAGER 0 0 2017-8-31 00:15 16 0
17 BACKGROUND sa . . master BRKR TASK 0 0 2017-8-31 00:15 17 0
18 BACKGROUND sa . . master BRKR TASK 0 0 2017-8-31 00:15 18 0
19 sleeping sa . . master TASK MANAGER 0 0 2017-8-31 00:15 19 0
20 sleeping sa . . master TASK MANAGER 0 0 2017-8-31 00:15 20 0
21 sleeping sa . . master TASK MANAGER 0 0 2017-8-31 00:15 21 0
22 sleeping sa . . master TASK MANAGER 0 0 2017-8-31 00:15 22 0
23 sleeping sa . . master TASK MANAGER 0 0 2017-8-31 00:15 23 0
24 sleeping sa . . master TASK MANAGER 0 0 2017-8-31 00:15 24 0
25 sleeping sa . . master TASK MANAGER 0 1 2017-8-31 00:15 25 0
26 sleeping sa . . master TASK MANAGER 0 0 2017-8-31 00:15 26 0
27 sleeping sa . . master TASK MANAGER 0 0 2017-8-31 00:15 27 0
29 sleeping sa . . master TASK MANAGER 0 0 2017-8-31 00:15 29 0
51 sleeping NT AUTHORITY\SYSTEM XNDFGJ . msdb AWAITING COMMAND 125 36 2017-8-31 00:15 SQLAgent - Generic Refresher 51 0
54 sleeping sa XNDFGJ . NewDB AWAITING COMMAND 171 0 2017-8-31 00:35 54 0
55 sleeping sa XNDFGJ . NewDB AWAITING COMMAND 0 0 2017-8-31 00:36 Microsoft SQL Server JDBC Driver 55 0
56 sleeping sa XNDFGJ . NewDB AWAITING COMMAND 0 0 2017-8-31 00:36 Microsoft SQL Server JDBC Driver 56 0
58 sleeping sa XNDFGJ . master AWAITING COMMAND 77 8 2017-8-31 00:57 Microsoft SQL Server Management Studio 58 0
59 sleeping sa XNDFGJ . NewDB AWAITING COMMAND 1785 13 2017-8-31 01:03 BusDispatch4.0 59 0
61 sleeping sa XNDFGJ . NewDB AWAITING COMMAND 0 0 2017-8-31 00:35 Microsoft SQL Server JDBC Driver 61 0
62 sleeping sa XNDFGJ . NewDB AWAITING COMMAND 281 9 2017-8-31 01:03 BusDispatch4.0 62 0
64 RUNNABLE sa XNDFGJ . master SELECT INTO 62 1 2017-8-31 00:52 Microsoft SQL Server Management Studio - 查询 64 0
65 sleeping sa XNDFGJ . GpsDB AWAITING COMMAND 0 72 2017-8-31 01:03 65 0
67 sleeping sa XNDFGJ . master AWAITING COMMAND 0 0 2017-8-31 00:55 Microsoft SQL Server Management Studio - 查询 67 0
USE master
GO
DECLARE @Sql NVARCHAR(max)=''
SELECT @Sql=@Sql+'KILL '+RTRIM(spid)+';' FROM sys.sysprocesses WHERE dbid=DB_ID('gpsDB2') AND spid!=@@SPID
EXEC (@Sql);
GO
--更改多用户(新用法)
ALTER DATABASE gpsDB2 SET MULTI_USER WITH NO_WAIT
--旧版用法
exec sp_dboption gpsDB2, N'single', N'false'--将目标数据库置为多用户状态