CTRL + R Issue in SSMS

Problem

 

I often use CTRL+R key to hide/show the result window, also use F7 & F8 keys to view the Object Explorer Details, Recently it stopped working after Microsoft windows Updates.

 

Whenever I hit "CTRL+R", The status bar says..."(Ctrl+R) was pressed. Waiting for the second key of chord..." as shown in the exhibit below

 

 

After followed below steps, the Key Functionalities are re-enabled

 

Solution

In SQL Server Management Studio,

 

1. Open the Tools menu,Options...



2. Under the Environment node click on the Keyboard node

3. Click the Reset button

4. Click Yes on the dialog that pops up

 



 This step will solve your issue. Hope This Help!

SQL Server Management Studio Query Designer Shortcuts

Problem

 

While writing and editing scripts, we often try to use the keyboard as much as possible. This should be the same for SQL Server scripts as well. When using the Query Designer in SSMS there are some shortcuts that will help you be more efficient and in this tip we will take a look at a few of these shortcuts.

 

Solution

As you know, shortcut keys play a vital role. A shortcut is a key or combination of keys assigned to perform an operation.

 

The best and familiar shortcut keys are:

• Save (CTRL + S) or (ALT + F + S)
• Copy (CTRL + C)
• Paste (CTRL + V)
• Cut (CTRL + X)
• Undo (CTRL + Z)
• Redo (CTRL + Y)

These are all familiar shortcuts keys which are common and standard across most of the modern operating systems and associated applications to perform the same activities.

 

In this tip, we will look at a couple of shortcut keys to work with the "Query Designer" editor in SSMS.

 

To Continue Reading >> Please Refer My Articles at MsSQLTips.com

Azure DB Backup/Restore Via SSMS 2014

This topic will provide details(on high level) of new features introduced in SQL Server 2014 Management Studio (SSMS) to Manage Azure Databases.

 

Enhanced Backup:SQL Server 2014 provides new Windows Azure integration to SQL Server's backup capabilities. You can specify a Windows Azure URL as the target for your SQL Server 2014 database backups. This new Windows Azure backup feature is fully integrated into SSMS.
 

In Backup Interface, you will see additional Option called "URL" as shown in the exhibit below,This option will backup the data on azure(cloud), 

 

Select "URL" as "Back up to" and provide the azure connection and file details to backup the data on azure.

 

Enhanced Restore: Same with the restores, you can choose URL as your Source…and provide the details accordingly as shown below.
 



 

Select "URL" and Click on "Add" Button

 

 

This backup and restore functionality are same or similar to when using DISK or TAPE, with a few differences.

 

Hope This Helps!

Turn Off “Saving Auto Recovery information” in Microsoft SQL Server Management Studio

Today I faced some problem, when I’m writing some query in SQL Server Management studio (SSMS) 2008. The problem is SSMS window is getting hang or stuck some seconds due to “Saving Auto Recovery information”. This is happened some interval of time. Then I tried to turn-off this option, but I can’t find out any option to turn-off.

I found somewhere, we can control it thru Registry, This is not good idea to edit the registry directly, but i couldn't found anyother solutions...

The following are the steps to Turn-off this “Saving Auto Recovery information” option

• Select Start, Goto Run
• Type RegEdit, Enter
• Go to this path

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\General\AutoRecover

Here you can find 3 fields as shown in the figure.

Double click on the “Auto Recover Enabled”, you can see the Edit window with current value “1”, change this value to “0” then press ok. If you want, you can Turn on this option by setting value to “1” on the same path.