Its around 40 columns - none of them text or ntext. I cant see any problems with disk space.
Thanks >What's quite a few? I have a couple of SQL tables with more than 100 >columns, one with over 200 columns, and have no problems at all... and >that's > > SQL 2005, Vista, CF8. > >You may have a problem with available memory or disk space. > > >Robert B. Harrison >Director of Interactive Services >Austin & Williams >125 Kennedy Drive, Suite 100 >Hauppauge NY 11788 >P : 631.231.6600 Ext. 119 >F : 631.434.7022 >http://www.austin-williams.com > >Great advertising can't be either/or. It must be &. > >Plug in to our blog: A&W Unplugged >http://www.austin-williams.com/unplugged > > >Status: sleeping >Command: AWAITING COMMAND >Blocked By: 0 > >Got a bit further - > >The table Im using has quite a few colums. I can do 'select top 33 *' but >not 'select top 34 *' > >Could there be some limit to the amount of data SQL can return? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328531 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
