January 15, 2003 at 4:34 pm
HI. Is there a way for a VB developer to terminate a connection(process) from within vb or query analzyer if they believe something they are running is in some type of loop? Currently they call me and ask me to kill that particular process which i do thru EM. I was wondering if this is something developers can do for themselves or should only the dba handle this.
Thanks!
Juanita
January 15, 2003 at 6:14 pm
I dont delegate this in production, they do have access on the dev server (we have a small team). You could put them in the processadmin role so that they can do it, I'd still restrict to one or two senior people, they can cause a lot of headache if they kill the wrong spid!
Andy
February 5, 2003 at 3:12 pm
We got an .aspx page that gets called so many times a second. for some reason the SQL server holds the connection even though the connection is explicitly closed. We, at this moment, assume that it is the inefficiency of the garbage collector of .net.
Is there a way I can terminate the connection(s) from a particular login (from a particular host) through SQL? This way, as a stop gap arrangement (I know this is stupid), I can run this sql at regular intervals and clear all the connections for this login (from this host)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply