테스트 중 생성한 유저와 데이터베이스를 삭제할 때 사용하는 쿼리. <div class="txc-textbox" style="border-style: solid; border-width: 1px; border-color: rgb(254, 254, 184); background-color: rgb(254, 254, 184); padding: 10px;">use [dbname]-- 현재 접속한 사용자 접속 끊기(where
절에 조건 확인)declare @kill_stmt nvarchar(10), @cntr intdeclare @kill_tbl table&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (ident int identity(1,1),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; spid int,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; loginame nvarchar(128),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dbid
int,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; dbname nvarchar(256)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; )&nbsp;insert into
@kill_tbl(spid,
loginame, dbid, dbname)Select sp.spid, sp.loginame, sb.dbid, sb.name as dbnamefrom master..sysprocesses sp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; inner
join master..sysdatabases sb on sp.dbid = sb.dbidwhere 1 =1
and&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --sb.name
= '[dbname]' and &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --loginame
= '[userid]' and&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; loginame &lt;&gt; 'sa'&nbsp;set @cntr = 1&nbsp;while @cntr &lt;= (select max(ident) from @kill_tbl)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; begin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Select
@kill_stmt = 'KILL '
+ convert(varchar, spid) from @kill_tbl where
ident = @cntr&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; exec&nbsp; (@kill_stmt)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select
@cntr = @cntr +
1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; end&nbsp;-- 사용자 삭제(해당 db에서 사용)IF&nbsp; EXISTS (SELECT * FROM sys.database_principals WHERE name = N'[userid]')&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; drop
user [userid]&nbsp;-- 사용자 로그인 삭제IF EXISTS (SELECT * FROM sys.syslogins WHERE name = N'[userid]') &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DROP
LOGIN [userid]&nbsp;-- 데이터베이스 삭제use masterdrop database
[dbname]

&nbsp;</div>

유저 및 데이터베이스 삭제 drop user, drop database