Thursday, December 02, 2010

SQL Server 2008: Edit Top 200 Rows

SQL Server 2005 and earlier versions had an Open Table command available when you right-click a table. This allows you to open the table and make edits to fields. In SQL Server 2008, the Open Table command is replaced with the Edit Top Rows command. The default for this is 200, which of course, is obnoxious.

To change this setting, follow these steps from SQL Server Management Studio (SSMS):
  • Tools > Options (This opens the General Scripting Options Dialog Box)
  • SQL Server Object Explorer > Commands
  • Table and View Options: Value for Edit Top Rows command (Change this value)

After modifying the setting, you will see that the menu is updated accordingly.

Microsoft (2010). Options (SQL Server Object Explorer/Commands). Retrieved December 2, 2010 from http://msdn.microsoft.com/en-us/library/cc280381.aspx.

1 comment:

michael said...

Thanks for teaching how to change this setting! I'm still new to SQL Server 2008 and currently enrolled in a Sql training program.

Blog Archive