Hi
am facing a problem and i dont know how to deal with it ,i had sql 2000 database that i need to upgrade to sql 2005 , the problem is that i have sorted views in this database but when i convert it to sql 2005 the result of view come unsorted i dont know whether it is a bug in sql 2005 or not but what am suffering of that i had a program that connect to this database and depend on the result of the sorted views (about 180 view ) is there a hotfix or any kind of treatment to fix the behaviour of the views in 2005
thanks
am facing a problem and i dont know how to deal with it ,i had sql 2000 database that i need to upgrade to sql 2005 , the problem is that i have sorted views in this database but when i convert it to sql 2005 the result of view come unsorted i dont know whether it is a bug in sql 2005 or not but what am suffering of that i had a program that connect to this database and depend on the result of the sorted views (about 180 view ) is there a hotfix or any kind of treatment to fix the behaviour of the views in 2005
thanks