??????????????????漰????????????????????????????￡???????SQLDMO??????????SQLDMO???ú????????????±??????????????????
???????????????????????￡???????????web.config?? ?????????????????????????????????????????????
??????????????????????????????????б??????????????????????????????????MASTER??????????????洢?????

 

createprockillspid(@dbnamevarchar(20))
as
begin
declare@sqlnvarchar(500)
declare@spidint
set@sql='declaregetspidcursorfor
selectspidfromsysprocesseswheredbid=db_id('''+@dbname+''')'
exec(@sql)
opengetspid
fetchnextfromgetspidinto@spid
while@@fetch_status<>-1
begin
exec('kill'+@spid)
fetchnextfromgetspidinto@spid
end
closegetspid
deallocategetspid
end
GO

???????????????????洢????????????dbname???????????????????±?????????????web.config???????????????????constr??

 

using System;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
namespace web.base_class
{
/// <summary>
/// DbOper????????SQLDMO????Microsoft SQL Server????????????
/// </summary>
public class DbOper
{
private string server;
private string uid;
private string pwd;
private string database;
private string conn;
/// <summary>
/// DbOper????????
/// </summary>