View more than 2000 rows
can somebody tells me how to view more than 2000 rows in sql server 2008R2? Thanks
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Amit ChoudharyPosted Aug 17, 2011, 5:08 AM
Change the values what ever number(of rows) you like to view in your table or view or in the Select Top N default query template.