sysdatabases에서 보면
1> select name,status,status2 from sysdatabases
2> go
name status status2
------------------------------ ------ -------
MYDB 8268 48
master 0 -32768
model 12 -32768
sybsystemdb 12 -32768
sybsystemprocs 12 -32768
tempdb 12 -32768
sp_who에서 보믄
1> sp_who
2> go
fid spid status loginame
origname hostname blk_spid
dbname cmd block_xloid
------ ------ ------------ ------------------------------
------------------------------ ---------- --------
------------------------------ ---------------- -----------
0 1 background NULL
NULL 0
MYDB MAINTENANCE TOKE 0
0 2 sleeping NULL
NULL 0
master DEADLOCK TUNE 0
0 3 sleeping NULL
NULL 0
master ASTC HANDLER 0
0 4 sleeping NULL
NULL 0
master CHECKPOINT SLEEP 0
0 5 sleeping NULL
NULL 0
.....
....
나오는데
어떠켛해 야 online 시킬수가 있나요....
|