I have a set of jobs that I run on one of our servers (Server 1). One of the jobs executes a stored proc on another server (Server 2), but it not finishing. Instead I received this:
OLE DB provider "SQLNCLI" for linked server "Server 2" returned message "Query timeout expired".
How can I prevent this? The job is copying tables from Server 1 to Server 2.