Why are the ODBC queries from my desktop is blocked by the sql server after running several queries in rapid succession? -
i create queries using visual foxpro 9.0 desktop computer ms sql server 2005 running on windows enterprise server (2003). queries repetitive , sometimes, 1 session query sql server 200,000 times in rapid succession. first few days, program running fairy sql server refusing process queries. on checking logs in sql server, found out spid killing query process: process id 71 killed hostname sqlserver, host process id xxxx. i confused because hostname not sql server querying sql server. from activity monitor noticed offending process id has following information: 62 no sa master sleeping 0 awaiting command sql agent - generic refresher .. the details shows message: set no_browsetable on lastly, thinking may problem visual foxpro, tried running queries desktop machine within sql server management studio, still encountered same problem when tried queries sql server: a transport-level error has occurred when sending request server. (provider:...