Asynchronous SQL VS 2003 .NET 1.1

[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?

 

[David Browne]

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?

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

 

[mbrierst]

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

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?

 

[David Browne]

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?

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

 

[mbrierst]

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

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.