SELECT TOP doesn't work

• zach_john

  SSCertifiable

  Points: 5922

  More actions

  November 5, 2001 at 2:57 pm

  #57877

  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

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  November 5, 2001 at 3:38 pm

  #419686

  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

  Andy
  Connect with me on LinkedIn

• zach_john

  SSCertifiable

  Points: 5922

  More actions

  November 6, 2001 at 8:35 am

  #419722

  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

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  November 6, 2001 at 9:30 am

  #419727

  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

  Andy
  Connect with me on LinkedIn