Founder Member of this blogspot PSD Nashik:- Honble. CPMG Maharashtra Circle Col.K.C. Mishra (VSM), Hon Ex. PMG AGD, T. Murti Sir, Honble. PMG Aurangabad Shri. M.E. Haque, Honble DPS HQ Mumbai Dr. Vinod Kumar, Honble DPS Aurangabad V. Ramulu, Supdt PSD Nashik Shri. M.S.Ahirrao, Sys Admn Shri. N.R.Pandav.

 

Wednesday, 29 October 2014

REMOVE ROW EDITING LIMITATION IN SQL 2008

0 comments

REMOVE ROW EDITING LIMITATION IN SQL 2008

Remove Row Editing Limitation In SQL 2008

In SQL Server 2008 Management Studio Express , we can change the default settings that allows to edit more than the 200 rows at a time, or select more than 1000 rows.

To modify the “Edit Top 200 Rows” or “Select Top 1000 Rows” settings do the following:

1.Run the SQL Management Studio Express 2008
2.Click the Tools -> Options
3.Select SQL Server Object Explorer . Now you should be able to see the options
*Value for Edit Top Rows Command
*Value for Select Top Rows Command
4.Give the Values 0 here to select/ Edit all the Records
5.Now we can see the Edit All and Select All options on the table.

0 comments:

Post a Comment

 
PSD-NASHIK © 2013