10 lines
476 B
HTML
10 lines
476 B
HTML
|
|
|
|
<div id="sina_keyword_ad_area2" class="articalContent ">
|
|
<div>create table #TempTable(spid int,ecid int,statusvarchar(32),loginname varchar(32),hostname varchar(32),blkint,dbname varchar(32),cmd varchar(32),request_idint); <wbr></div>
|
|
<div>insert into #TempTable <wbr></div>
|
|
<div>exec sp_who; <wbr></div>
|
|
<div>select * from #TempTable where [dbname] = 'DataBaseName' andHostName = 'PCName'</div>
|
|
<div>drop table #TempTable <wbr></div>
|
|
</div>
|
|
|