Suresh Kumar M

How to Change Edit 200 Rows and Select Top 1000 Rows Default Value in SQL Server Management Studio 1. Login to SQL Server Manatement Studio 2. Go to Tools Menu and Options 4. To make the necessary changes within the Options Dialog box, Expand SQL Server Object Explorer -> Commands. 5. Specify the new value for Value for Edit Top Rows Command and Specify the Value for Select Top Rows Command. In the below example we have set the value as 50 for both options 6. Finally to save the changes click OK to save the changes to SSMS configuration. 7. Once you have made the above mentioned changes right click the table to see the changes as shown in the snippet below

Function key freezes AutoCAD while in a draw or modify command Issue: AutoCAD freezes when pressing F8, or any other function key, while in an active command. Solution: Do the following: Install the latest updates for AutoCAD. For AutoCAD 2017, install the 2017.1.2 update. For AutoCAD 2016, install the AutoCAD 2016.0.11 Update. As an alternative, to work around the issue without the updates, do one or more of the following: On the command line in AutoCAD, type TEMPOVERRIDES and change the value to 0 (zero). Turn ortho and other functions on and off via the Status Bar. Type in ORTHO at the command line instead of using the function key. Rollback the Anniversary update (Microsoft allows only 10 days to do this