Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TOP 100 PERCENT balking
Message
From
28/02/2006 17:32:16
Sergey Berezniker
New York, United States
 
 
To
28/02/2006 16:33:01
Cheryl Qualset
Qualset Computer Consulting
Davis, California, United States
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Title:
Re: TOP 100 PERCENT balking
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01100064
Message ID:
01100180
Views:
19
>The current compatibility level is 65.
>
>Are we on to something here? Should it be set to 80?

Yes if you want to use all new features introduced after SQL 6.5. Otherwise they will be disabled and TOP clause is one of them.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform