sql management studio Timeout expired

sql management studio Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

This can be a pain when you want to make changes that affect tables with large quantities of data

There are three location syou will need to check

In managament studio

1.
Tools > options > Query Execution > SQL server > General

verify Execution time-out. for unlimited timeout set to 0

2.
Tools > options > Designers > Table and Database designers

verify Transaction time-out. for unlimited timeout set to 0

3.
when you first make the database connection, in the connection window popup, click on “options”. select the “connection properties” tab and verify the “connection time-out” and “execution time-out” are set to your liking. once again 0 is unlimited

Leave a Reply

Your email address will not be published. Required fields are marked *