Francisco H Tapia
my.lists at verizon.net
Mon Mar 17 15:24:32 CST 2003
ouch that is a problem, Do you have another disk on that server? if so maybe try moving the tempdb over to that disk in order to enable your query to run. -Francisco http://rcm.netfirms.com On Monday, March 17, 2003 1:08 PM [GMT-8], Fred Hooper <fahooper at trapo.com> wrote: : I need to combine data sources that feed a BI program (Cognos). The : equivalent process with pure SQL Server would be to have a view that : SELECTs from another view containing multiple UNIONs. My question is: : Will this result in a table in TempDb representing the UNION'd tables? : : If so, I don't have enough disk space. I'd rather not try it out : blind, do I'm grateful for any ideas. :