User does not have permission to use the KILL statement.

Details
Product: SQL Server
Event ID: 6102
Source: MSSQLServer
Version: 8.0
Component: SQL Engine
Message: User does not have permission to use the KILL statement.
   
Explanation
KILL permissions default to the members of the sysadmin and processadmin fixed database roles, and are not transferable.
   
User Action
Log in as a member of the sysadmin or processadmin fixed database roles. Then reissue the KILL statement.

Related:

Leave a Reply