As part of sql server DB Performance benchmark, i have created one console application using VS 2010.
The application runs simple SQL Queries Cyclically.
application works fine if the query is retriving data less than one day data.
the following exception i got if the query is retriving 07 Days of data
System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
Please help me how to resolve the issue...
can u plz elaborate the network down means......
Note: The error i got only when the data retriving for more days.
I am using the connection pooling.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?