KILL Command in MSSQL Databases

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Derftics
    New Member
    • Apr 2007
    • 16

    #1

    KILL Command in MSSQL Databases

    Hi,

    I would like to ask your opinion or idea. I have a user who wants to have an access to kill the processes in MSSQL that blocks his process (development side), unfortunately I cannot add his user id in the "sysadmin role". Due to some company ruling for developers.

    I have tried incorporating the "kill" command in a stored procedure to solve this problem unfortunately kill command doesnt except passing parameter.

    Please is anyone have an idea how i can give him access to kill user process without granting him the sysadministrato r role?

    Thanks a lot.
Working...