USE master
GO
EXEC sp_configure 'remote query timeout', 6000 
GO
RECONFIGURE
GO