Paul Nielsen
pauln at sqlserverbible.com
Fri Feb 1 08:52:52 CST 2008
Even of it takes hours? Can you show us the SQL and the Query Execution Plan? -Paul -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Friday, February 01, 2008 5:55 AM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Timeouts executing views When I try to execute a view, if results aren't returned within some short period of time (about 30 seconds) I get a timeout message. OTOH, if I copy the Sql, open a new query, paste it in and run, it will complete even if it takes hours. Does anyone know where to go to change the timeout period for views run directly? John W. Colby Colby Consulting www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com __________ NOD32 2843 (20080201) Information __________ This message was checked by NOD32 antivirus system. http://www.eset.com