Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ranvir_2k
Posting Yak Master
180 Posts |
 Posted - 2011-03-07 : 05:09:10
|
| Is there any other way to grant a login 'Kill SPID' permissions without granting sysadmin? |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-03-07 : 08:25:41
|
quote:
From BOL:Requires the ALTER ANY CONNECTION permission. ALTER ANY CONNECTION is included with membership in the sysadmin or processadmin fixed server roles
- LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
 |
|
|
|
|
|
Granting kill spid permissions