Nov 24 2011

What Happened To Open Table in SQL Server 2008 Management Studio?

Category: CrashingDutchman @ 09:36

When you start to use Sql Server Management Studio 2008 maybe the first change you’ll realize is Select Top 1000 Rows and Edit Top 200 Rows commands instead of Open Table command in 2005.

If it is hard for you to leave old habits or you want to change 200 and 1000 parametric you can change these parameters in Management Studio. The only thing you should do is to open Options Window under Tools menu then on the left select Commands node under Sql Server Object explorer node. When Commands is selected you can change the functionality of these commands by changing related values.

Also, you can make these commands work for entire table by setting values to 0.

From: Tamer Öz blog