Brad Marsh alerts us to this handy option in SQL Server 2008 - how to change the default result set sizes. They default to 200 for Edit and 1000 for Select, but can be increased to... everything if desired. Proceed with caution though - there's a reason Microsoft put these new limits in.