"select * from table" and "select top 14260 from table" get nothing but select top 14259 get result successful

Why do you think it is a bug? It is possible that rows started with 14260 get locked...

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/



MS SQL optimization: MS SQL Development and Optimization

MS SQL Consulting: Large scale of database and data cleansing

Remote DBA Services: Improves MS SQL Database Performance

SQL Server Integration Services: Business Intelligence