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-05-06 : 14:30:41
|
Andrew writes "Hi,
I am running an ASP web application on NT4 server, and when running my SQL query (just a simple "SELECT * FROM view WHERE column IS NULL" - unfortunately the view does hold a lot of data but I am not allowed to change the way the view has been constructed) I get the following error...
Microsoft OLE DB Provider for SQL Server error '80040e31'
Timeout expired
I have set the server script timeout to 300 and I have checked the SQL settings through enterprise manager and the timeout there is set to the default (unlimited). Yet I still get the error (if I change my SQL string to something other than "IS NULL" then it runs without errors).
Could you possibly tell me what setting I need to change, or is there a more efficient way I can do this in SQL without using "IS NULL".
Thanks,
Andrew" |
|
|
|
|
|
OLE DB provider timeout error