Data Masking Software Resources

change the timeout of the query; right click a-> server => select properties -> Remote server connections => remote query timeout field. Give a big number there

Show More

Show Less

Depends what you are doing. If you ran a stored procedure than it will finish but that also depends how you coded transaction handling in the stored procedure. If you are just doing a simple select of an insert and the connection is broken. Then Sqlserver will rollback in case of an insert. A simple select will be terminated. If you want to guarantee the fact that you want to be able to work on after a connection loss then you should transfer your SQL into a stored procedure and in that stored procedure you program that the next time the stored procedure is executed ( after a connection loss) that it will continue the job it was doing by looking into a status table where it can pick up were it left.

Show More

Show Less

You can change the timeout for the query: In the object explorer, right click a server and select properties. Go to Remote server connections, look for the remote query timeout field; then type or choose a value from 0 to 2,147,483,647 to establish the maximum number secs that SQL Server will wait before timing out

Show More

Show Less