Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-25 : 08:49:24
|
| Bhuwnesh writes "I have a stored procedure with 1000 parameters. We are using this in VB component for a Web application. This works fine with our development setup. On implementing this on QA setup (that contains different SQL server and DBs) the application gives '[Microsoft][ODBC SQL Server Driver]Timeout expired' error.While on this QA setup it works well on query analyzer with same parameter values. Interestingly, if I reduce the number of parameters to 850 it works fine.My concern is how it is working fine on our dev setup with 1000 parameters and why it is not working on QA setup.Do I change some setting at SQl server level?" |
|
|
|
|
|
resource timeout for a procedure