SQLSERVER2005下，分页失败？?报错

我在SQL2000下是可以的，但到2005下就报错了。不知道什么原因？

报错日志如下：

2014-08-14 09:53:25,818 [http-apr-8091-exec-5] WARN  org.nutz.mvc.impl.processor.FailProcessor - Error@/stbprp/list :

org.nutz.dao.DaoException: org.nutz.dao.DaoException: !Nutz SQL Error: 'select * from(select row_number()over(order by __tc__)__rn__,* from(select top 100 0 __tc__,  a.*,b.sknm,c.dsc as addvnm from st_skjzqk_b a left join st_skjbqk_b b on a.skbh=b.skbh left join adcd_b c on a.addvcd=c.adcd where a.addvcd like '%' order by a.skbh asc,a.stcd asc)t)tt where __rn__ > 0'