To protect your nerves, the server inserts a TOP 2000 phrase unless you
give a limit yourself. Thus, if you hit the 2000 record limit and want
to override it, you can specify your limit yourself (like SELECT TOP
There is a fixed limit to 100000 rows on this service. If this
bugs you, use TAP.