Changing the default value of “Edit Top 200 Rows” – SQL Server 2008
The SQL Server 2005 Management Studio allows us to “Edit” and “View” the whole set of records in a table. But in SQL Server 2008 Management Studio, this flexibility was restricted. SQL Server 2008 by default allows us to select top 1000 records and allows us to edit top 200 records. If our records in a table are more than the default numbers, SQL Server 2008 won’t display those records or allows us to edit those records. We can increase those default value.
Here are the steps…
1. Open SQL Server 2008 Management studio.
2. Right Click on any of the table. It will display the default value.
3. Go to “Tools” > “Option” > “SQL Server Object Explorer” > “Command”.
4. Change the default value to your desired value. Here i am entering “10000″.
5. Now go and check again. The value gets changed.
We successfully changed the default value to our desired value.
Worth noting, possibly introduced with SP1, but SSMS (I’m running 10.0.2531.0) now supports editing and selecting “all rows” by providing a value of zero (0) per the process described above.
Hi Neil,
Thanks for your information. Initially, we have faced some problems in selecting and editing the records in SQL Server 2008. We found this option and changed the numbers to our desired limit.
Actually, your response for my post helps us a lot. Once again i am thanking you for sharing your knowledge.
Regards,
Sujeev
Thank you!
Thanks Dude ! that was a great help
Thankz yaar
Good, thanks