On your SQL Server Management Studio 2008, On your Tools menu, navigate as follows:
Tools -> Options... -> SQL Server Object Explorer -> Commands
You can change the Value for Edit <n> Rows command to any number you need. If you set 0, you will be able to edit all rows - so it will have functionality of Edit All Rows when using right click on the given table to edit table rows.
Source:
http://mkdot.net/blogs/hajan/archive/2010/08/31/editing-rows-in-sql-server-management-studio-2008.aspx
Tools -> Options... -> SQL Server Object Explorer -> Commands
You can change the Value for Edit <n> Rows command to any number you need. If you set 0, you will be able to edit all rows - so it will have functionality of Edit All Rows when using right click on the given table to edit table rows.
Source:
http://mkdot.net/blogs/hajan/archive/2010/08/31/editing-rows-in-sql-server-management-studio-2008.aspx
No comments:
Post a Comment