Hi

I have a .net 2.0 desktop application which randomly gets the following exception when executing a stored procedure in MS SQL 2005. The stored procedure is a simple select query...

A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - A blocking operation is currently executing.)

The calling code looks like this..

try
{
DataTable myTable = new DataTable();
SqlDataAdapter myAdapter = new SqlDataAdapter(sqlCommand);
myAdapter.Fill(myTable);
return myTable;
}
catch (Exception ex)
{

}


Any help on explaining this or any other hints on how to solve it would be enormously appriciated!

/Patrik

You're executing 2 or more database requests on the same connection object.