Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nimcreat
Starting Member
9 Posts |
 Posted - 2011-04-26 : 22:10:08
|
| Hello,We have a program written in Visual Dataflex however despite the index showing in SQL 2005 as ascending the data shown in our program is not reflecting that.We had this running on SQL Server 2005 on another server and it was fine. But this issue has occurred since we were forced to move everything to a new machine. We tried a fresh install of SQL Server 2005 on another machine and had exactly the same problem. We have tried using the latin1_CI_AS collation and SQL_LATIN1_CI_AS as default collation but neither has made any difference.Environment:Original was: Server 2008 R1 with SP1New is: Server 2003 with SP3All are 64 bit environments.Database Server: SQL Server 2005 SP 2 and SP3We have tried service packing SQL but to no avail. We've tried different collations as above. The studio enforces that ARTHIBORT must be set to on in SQL in order to use uppercase indexes. We have done a thorough search on the internet and can't find any clues as to how to solve this issue so any suggestions would be greatly appreciated. Thanks in advanceThanks In AdvanceJohn |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL Sort order specified not working