- Joined
- Jul 20, 2007
- Messages
- 3,055
- Likes received
- 8
- Thanks received
- 2
- Location
- Germania
Hi
I am working in the Management Studio on a MSSQL2005 and on a complex view I get a "Timeout expired" message after 30 seconds when I try to execute the query.
I have looked in several places and changed the timeout settings from the standard 30 sec to something else like 120 sec but I still get the timeout problem.
It is my own database so I can change settings without restrictions.
Do you guys know the magic bullet for this problem?
I am working in the Management Studio on a MSSQL2005 and on a complex view I get a "Timeout expired" message after 30 seconds when I try to execute the query.
I have looked in several places and changed the timeout settings from the standard 30 sec to something else like 120 sec but I still get the timeout problem.
It is my own database so I can change settings without restrictions.
Do you guys know the magic bullet for this problem?