You must Sign In to post a response.
  • Category: ASP.NET

    How to stop/kill the query of perticular user?

    I have created one webform(using C#).Onclick of button,I am executing query,showing time that sp take.I want to stop/kill that query.How to find out query which is executed by perticular user.I want to kill query of perticular user not other.How to do that?
  • #765902
    its not a easy task I guess.
    I think you need to first get the current user first using 'CURRENT_USER ' method, it returns the name of the current user. This function is equivalent to USER_NAME().
    checkout below link
    https://technet.microsoft.com/en-us/library/aa172599(v=sql.80).aspx

    Thanks
    Koolprasd2003
    Editor, DotNetSpider MVM
    Microsoft MVP 2014 [ASP.NET/IIS]


  • Sign In to post your comments