Asynchronous SQL VS 2003 .NET 1.1

  • Thread starter Thread starter mbrierst
  • Start date Start date
M

mbrierst

Is it at all possible to do asynchronous SQL queries with Visual
Studio 2003 / .NET version 1.1? I know this can be done with VS
2005 .NET 2.0, but that's not an option for me right now. Is there
any way at all to do this, or am I out of luck?
 
Is it at all possible to do asynchronous SQL queries with Visual
Studio 2003 / .NET version 1.1? I know this can be done with VS
2005 .NET 2.0, but that's not an option for me right now. Is there
any way at all to do this, or am I out of luck?
Click to expand...

You can always spawn a thread to run a query, but in .NET 1.1 running a
query will always block the thread that executes the command.

David
 
You can always spawn a thread to run a query, but in .NET 1.1 running a
query will always block the thread that executes the command.

David
Click to expand...


So am I correct that this also means that once an sql query has been
started there is no way at all to kill it in .NET 1.1?
 
So am I correct that this also means that once an sql query has been
started there is no way at all to kill it in .NET 1.1?
Click to expand...

You are correct. Well you could record the spid before you start the query
and KILL it from another thread and another (sysadmin) connection, but other
than that, there's no way.

David
 
You are correct. Well you could record the spid before you start the query
and KILL it from another thread and another (sysadmin) connection, but other
than that, there's no way.

David
Click to expand...

Thanks for the advice.

Pretty disappointing. Unfortunately I don't have sysadmin access on
production databases, so KILL is always a pain for me. I'll just have
to live without this and hope for the best I think.
 
Back
Top