Michael Maddison
michael at ddisolutions.com.au
Sun Nov 26 16:34:39 CST 2006
John, "But no one is addr5essing why the thing gives an error and stops when I try to run a view and main memory runs out." It's not an error from SQL, at least not on the surface, its whatever client you are using that is timing out. AFAIK SQL will attempt to run a query forever... unless limits are placed on it. The limits can come from clients OR from SQL. Check the database properties and see if you set the timeout at some stage. IIRC 0 means run forever. Grab the execution plan from QA for the query and post it, it may tell us something. cheers Michael Maddison DDI Solutions Pty Ltd michael at ddisolutions.com.au Bus: 0260400620 Mob: 0412620497 www.ddisolutions.com.au