SQL Server - Select All Rows rather than Select TOP 1000

When you right Click on a table, you simply find the first option Select TOP 1000 rows.

But you can change it to ALL rows i.e. all the rows will be displayed without limitations.

Just follow these steps.

GoTo:

Make sure that SQL Management studio is open.

Then goto Tools --> Options --> SQL Server Object Explorer

Same as in image.

Then select Commands in it

& then set all the values 0

Click on OK

That's it !!