Showing posts with label SQL Server Management Studio. Show all posts
Showing posts with label SQL Server Management Studio. Show all posts

Friday, June 17, 2011

Editing rows in SQL Server Management Studio 2008

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