In SQL Server 2008 Management Studio Express , we can change the default settings that allows to edit more than the 200 rows at a time, or select more than 1000 rows.
To modify the “Edit Top 200 Rows” or “Select Top 1000 Rows” settings do the following:
1.Run the SQL Management Studio Express 2008
2.Click the Tools -> Options
3.Select SQL Server Object Explorer . Now you should be able to see the options
*Value for Edit Top Rows Command
*Value for Select Top Rows Command
4.Give the Values 0 here to select/ Edit all the Records
5.Now we can see the Edit All and Select All options on the table.
To modify the “Edit Top 200 Rows” or “Select Top 1000 Rows” settings do the following:
1.Run the SQL Management Studio Express 2008
2.Click the Tools -> Options
3.Select SQL Server Object Explorer . Now you should be able to see the options
*Value for Edit Top Rows Command
*Value for Select Top Rows Command
4.Give the Values 0 here to select/ Edit all the Records
5.Now we can see the Edit All and Select All options on the table.
No comments:
Post a Comment