How to Change Edit 200 Rows and Select Top 1000 Rows Default Value in SQL Server Management Studio

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

Comments

Post a Comment

Popular posts from this blog

MS Office 2013 Activation Command Line

 Microsoft Office Activation Command Line Permanently Activate Microsoft Office 2013 Without Any Software And Product Key Step 1. Open Notepad copy and paste below mention commands and save msoffice.cmd the right click msoffice.cmd and click run as administrator @echo off title Activate Microsoft Office 2013 Volume for FREE!&cls&echo ============================================================================&echo #Project: Activating Microsoft software products for FREE without software&echo ============================================================================&echo.&echo #Supported products:&echo - Microsoft Office 2013 Standard Volume&echo - Microsoft Office 2013 Professional Plus Volume&echo.&echo.&(if exist "%ProgramFiles%\Microsoft Office\Office15\ospp.vbs" cd /d "%ProgramFiles%\Microsoft Office\Office15")&(if exist "%ProgramFiles(x86)%\Microsoft Office\Office15\ospp.vbs" cd /d "%ProgramFiles
Read more

Matrix Cosec - IN and OUT Events is there but Attendance is not calculate how to rectify?

Image
1).            If employee Events is there but attendance report not showing the event. How to rectify ? Ans:      option 1. Login to Cosec Software and Click Users > User List > Search the User > Click Edit > Select General > Check the Joining Date (If Joining Date greater than current working days Attendance Report not show. After Joining date only attendance report will show)             Option 2. . Login to Cosec Software and Click Users > User List > Search the User > Click Edit > Select T&A > Check Enable Attendance Calculation (If uncheck Enable Attendance Calculation Attendance will not marked the user)             Option 3. Login to Cosec Software and Click Users > User List > Search the User > Click Edit > Select Devices> Uncheck Restrict Attendance (If your Checked the Restrict Attendance User will allow the door access but attendance not marked) For Option: 1 For Option: 2 For Opti
Read more

Cisco WebEx Room Kit Series Configuration - Step by Step Simple method

CISCO   WebEx   Room   Kit   Series. -  Configuration - Step by Step Thereafter follow the steps :   Basic Steps Using Touch 10 for Device : Welcome Screen -> Change Language -> English (United Kingdom) -> Back Welcome Screen -> Start No Network Connection Screen -> Next Ethernet Settings -> Disable DHCP & Enter All Static IP Address Details -> Next Select “Other Settings” Select Advanced Set-Up -> Next Change Time Zone -> Southern Asia -> Colombo, New Delhi -> 12 Hours / 24 Hours -> Next Skip Step related to using Device as External USB Camera -> Next Adjust Camera View (Manual) -> Next Sound Check (Auto) -> Next Set-Up Complete Screen -> Next “Welcome” Screen appears on Touch 10.   Web-Login using IP Address of Device : Setup -> Configuration -> System Unit -> Name -> Define Name as per Customer for Identification. Setup -> Configuration -> Conference -> Default Call Protocol -> H.323 -> Save Setup -> C
Read more