Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TOP n clause - Syntax Error
Message
From
30/03/2000 08:24:04
Michael Levy
Cincinnati, Ohio, United States
 
 
To
30/03/2000 04:23:49
Jiri Puncochar
Transoft
Ceske Budejovice, Czech Republic
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Re: TOP n clause - Syntax Error
Miscellaneous
Thread ID:
00352598
Message ID:
00352642
Views:
10
Jiri,

I got bit by this once before. When you upgrade, the Upgrade wizard leaves the database in 6.5 compatability mode. Use the sp_dbcmptlevel system stored procedure to switch the database to 7.0 compatability.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform