- 
    
Bug
 - 
    Resolution: Duplicate
 - 
    
Highest
 - 
    None
 - 
    3.5.1
 - 
    None
 - 
    
Using Confluence 3.5.1 and SQL server 2008 or 2005
 
When using SQL server 2008 or 2005 and trying to move a page to another place or other space gives an error:
2011-04-06 14:37:19,123 ERROR [http-8081-9] [atlassian.confluence.servlet.ConfluenceServletDispatcher] sendError Could not
 execute action url: /pages/movepage.action | userName: xxxxx | referer: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: error performing findBySQL; uncategorized SQLException
 for SQL []; SQL state [S1000]; error code [421]; The ntext data type cannot be selected as DISTINCT because it is not 
comparable.; nested exception is java.sql.SQLException: The ntext data type cannot be selected as DISTINCT because it is not 
comparable.
Caused by: java.sql.SQLException: The ntext data type cannot be selected as DISTINCT because it is not comparable.
Workaround Available
See CONF-22164 for details.
- duplicates
 - 
                    
CONFSERVER-22164 Many page operations: move, restricting, deleting, etc. fail with Oracle, DB2 or SQL Server
-         
 - Closed
 
 -         
 
- is caused by
 - 
                    
CONFSERVER-21371 Page move fails with deep page hierarchy
-         
 - Closed
 
 -