Saturday, 28 July 2012

Edit more than 200 rows in SQL Server 2008

To edit more than 200 rows of SQL Server 2008


1- Open SQL Server 2008 Management Studio

2- Goto Tools

3- Click "Options"

4- Expand the tree of "SQL Server Object Explorer"

5- Click "Commands"

6- Change "Value for edit top < n > rows command" to 0

7- Change "Value for select top < n > rows command" to 0

8- Click "OK"

No comments: