CSS SQL Server Engineers

This is the official team Web Log for Microsoft Customer Service and Support (CSS) SQL Support. Posts are provided by the CSS SQL Escalation Services

How It Works: XEL Display in SQL Server Management Studio (SSMS) Row Limit

How It Works: XEL Display in SQL Server Management Studio (SSMS) Row Limit

Rate This
  • Comments 3

This is a simple issue but if you don't expect the behavior it can surprise you.

The grid, used by SSMS, is limited to a maximum number of rows, that can be displayed, of 1 million.   

Note:  There is no warning dialog or flashing toolbar.

Shown in the figure below is the display vs event totals.

clip_image001


The design is an internal, display filter always including TOP 1000000.   

You may adjust other filter criteria, such as the time rage, event type, and up to the first 1 million rows meeting the filter criteria are displayed.

Bob Dorr - Principal SQL Server Escalation Engineer

Leave a Comment
  • Please add 1 and 4 and type the answer here:
  • Post
  • Copy/Paste does not work properly neither. Some of the rows are missing when I'm trying to copy a "bigger" result set from the grid view. When I set the results to file, I got all rows. I have got the same behavior with SSMS 2008 as well.

  • Copy/Paste does not work properly neither. Some of the rows are missing when I'm trying to copy a "bigger" result set from the grid view. When I set the results to file, I got all rows. I have got the same behavior with SSMS 2008 as well.

  • Handy to know thanks.

Page 1 of 1 (3 items)