• My question is simple what is the different on TEXT data type from sql 2000 to sql 2008?

    Why same table , same data size , same column, same statement works in sql 2000 SP 4 but hangs on sql 2008 R2, the db restored from sql 2000 backup to sql 2008 R2

    Thanks