Error Message:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
![image image](https://www.vijaykodali.com/Blog/image.axd?picture=image_thumb_1.png)
Reason:
Default execution timeout value in SQL Studio is 30 seconds
Solution:
Increase the execution & connection timeout value while opening new query window(File --> New --> Database Engine Query)
![image image](https://www.vijaykodali.com/Blog/image.axd?picture=image_thumb_2.png)
![image image](https://www.vijaykodali.com/Blog/image.axd?picture=image_thumb_3.png)