SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in Show Table Data      SoftTree Technologies Forum Index » SQL Assistant View previous topic View next topic Show Table Data Author Message adeilson Joined: 15 Jan 2010 Posts: 4 Country: Brazil Show Table Data Hello, I have a problem to display data in a table. The next image attached! Fri Jan 15, 2010 9:06 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7948 Which version of SQL Server do you connect to? What do you get when you execute SELECT TOP 100 * FROM turno in SQL Query Analyzer? Fri Jan 15, 2010 9:52 am adeilson Joined: 15 Jan 2010 Posts: 4 Country: Brazil It's the same error. The version of SQL Server 2000 with compatibility level 6.5. Fri Jan 15, 2010 9:59 am adeilson Joined: 15 Jan 2010 Posts: 4 Country: Brazil Is there a setting to delete the TOP? Fri Jan 15, 2010 10:00 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7948 I'm sorry, we don't support this dinosaur. SQL Server Version 6.6 (or 6.5 compatibility mode) is almost 20 years old. Nobody supports it anymore. It is like running Windows 3.1 with DOS 3. The minimum supported version is SQL Server 2000 SP1. For the data preview, there is no way to remove TOP keyword, that feature is built-in and is used to limit the size of the result, basically to get data sample for preview only. I suggest to change the compatibility mode to something more usable. Fri Jan 15, 2010 10:09 am adeilson Joined: 15 Jan 2010 Posts: 4 Country: Brazil So I'll be uninstalling this software. I would buy 5000 licenses. Thanks for nothing! Fri Jan 15, 2010 10:35 am maxpesola Joined: 26 Nov 2007 Posts: 51 adeilson wrote: So I'll be uninstalling this software. I would buy 5000 licenses. Thanks for nothing! If you had the money for 5000 licenses, i do not think you would use that very old version of the database, without even update it to at least sp1 for free, we are at sp4! Tue Jan 19, 2010 5:33 am Display posts from previous:  All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First     SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours Page 1 of 1   Jump to:  Select a forum ----------------SQL AssistantDB Audit, DB Mail, DB Tools24x7 Scheduler, Event Server, Automation SuiteTips & Snippets Repository You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum     Powered by phpBB © 2001, 2005 phpBB Group Design by Freestyle XL / Flowers Online.