moved from ms sql 2000 to ms sql2005

Giganews Newsgroups
Subject: moved from ms sql 2000 to ms sql2005
Posted by:  HandersonVA (handerson…@hotmail.com)
Date: 3 Aug 2006

database has been recently upgraded from ms sql 2000 to ms sql 2005.
are there anything I need to be aware after upgrading to ms sql 2005?

for my experience, i got an error if i use column alias in ORDER BY
clause which was fine on ms sql 200.

thanks

Replies