SELECT TOP doesn't work
-
The databases that were upgraded from 6.5 to 7.0 don't seem to support this select statement. All others are fine!
John Zacharkan
John Zacharkan -
You're in 6.5 compatibility mode. Top wasn't a feature of TSQL until 7.0. Take a look at BOL for sp_dboption to see how to change it.
Andy
-
Looks like you're talking about setting the sp_dbcmptlevel
Any reason why the upgrade did not set this to 7.0? Does not upgrading the master database have anything to do with this?
John Zacharkan
John Zacharkan -
I believe the default is to leave in 6.5 mode. Which makes sense, you get the improvements of 7.0 (most of them) while not breaking your app. I'll agree they could do a better job explaining this.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply