Hello to all
I am working in windows server 2008. In this i have installed SQL Server 2005. I made views (with 7-8 tables)in it. My database is around 40 GB. Now i am running my view but it is not running and giving error --
" SQL Execution Error
Error Source :- .Net Sqlclient Data Provider
Error Message:- Time out expired. The timeout period elapsed prior to completion of the operation or the server is not responding "
Can anybody help me. It's very urgent. I am trying to solve this problem since last week but nothing could help.
I increase the execution time of SQL Server from going to Tools--> Options --> Query Execution Tab. But this doesnot work. I am thinking may be it is because of OS.
Can anybody help me out
Thanks in advance
View Complete Post