SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2008 R2
Product Documentation
SQL Server 2008 R2 Books Online
Database Engine
Technical Reference
SQL Server Management Objects (SMO) Class Library
Microsoft.SqlServer.Management.Smo Namespace
Server Class
Server Methods
AddDatabaseContext Method
Alter Method
AttachDatabase Method
CheckObjectState Method
CompareUrn Method
DeleteBackupHistory Method
Deny Method
DetachDatabase Method
DetachedDatabaseInfo Method
EnumActiveCurrentSessionTraceFlags Method
EnumActiveGlobalTraceFlags Method
EnumAvailableMedia Method
EnumCollations Method
EnumDatabaseMirrorWitnessRoles Method
EnumDetachedDatabaseFiles Method
EnumDetachedLogFiles Method
EnumDirectories Method
EnumErrorLogs Method
EnumLocks Method
EnumMembers Method
EnumObjectPermissions Method
EnumPerformanceCounters Method
EnumProcesses Method
EnumServerAttributes Method
EnumServerPermissions Method
EnumStartupProcedures Method
EnumWindowsDomainGroups Method
EnumWindowsGroupInfo Method
EnumWindowsUserInfo Method
GetActiveDBConnectionCount Method
GetBoolParameter Method
GetConnection Method
GetDefaultInitFields Method
GetParameter Method
GetPropertyNames Method
GetSmoObject Method
GetStringComparer Method
GetStringParameter Method
GetUrnRecursive Method
Grant Method
IAlienRoot.DesignModeInitialize Method
IAlienRoot.SfcHelper_GetDataTable Method
IAlienRoot.SfcHelper_GetSmoObject Method
IAlienRoot.SfcHelper_GetSmoObjectQuery Method
Initialize Method
IsDetachedPrimaryFile Method
ISfcDomainLite.GetLogicalVersion Method
ISfcHasConnection.SetConnection Method
IsWindowsGroupMember Method
KillAllProcesses Method
KillDatabase Method
KillProcess Method
PingSqlServerVersion Method
ReadErrorLog Method
Refresh Method
Revoke Method
Script Method
ScriptImpl Method
SetDefaultInitFields Method
SetTraceFlag Method
Expand Minimize
This topic has not yet been rated - Rate this topic

Server.KillProcess Method

SQL Server 2008 R2

Stops the specified process.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
C#
C++
F#
JScript
VB
Copy 
public void KillProcess(
	int processId
)

Parameters

processId
Type: System.Int32
An Int32 that specifies the system ID value that uniquely identifies the process.

Visual Basic

Copy 
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Stop all processes running on the AdventureWorks2008R2 database.
srv.KillAllProcesses("AdventureWorks2008R2")
'Stop the AventureWorks database.
srv.KillDatabase("AdventureWorks2008R2")
'Stop the specified process with ID 52.
srv.KillProcess(52)

PowerShell

Copy 
$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
$srv.KillAllProcesses("AdventureWorks2008R2")
$srv.KillDatabase("AdventureWorks2008R2")
$srv.KillProcess(52)
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.