Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Blog

:

Quick Launch

Blog > Posts > Copy Nothing Checkbox in SQL Server Management Studio
July 02
Copy Nothing Checkbox in SQL Server Management Studio

When using SQL Server 2005 Management Studio, I sometimes had a strange experience:

  • I would cut some important text onto the clipboard
  • I would position the cursor where I wanted to paste the text
  • I would accidentally copy (Ctrl-c instead of Ctrl-v)
  • When I then tried to paste, the clipboard would be empty--I would have copied "nothing" onto the clipboard, and lost the text I was trying to move!

The obvious solution is to undo back to the point when the text did exist, and then try again. However, I recently noticed the Apply Cut or Copy commands to blank lines when there is no selection setting in Management Studio (near the middle of screenshot):

Management Studio Options dialog

With the standard installation, it is at least partially on by default.

As I understand it, leaving the box checked allows you to get a blank line onto the clipboard when you copy or cut "nothing". Since you can also get a blank line by pressing Enter, and it's one key press rather than four, I don't understand why this feature exists, and certainly why it's on by default!

I've now unchecked the box, and it now works like nearly all other Windows programs: if I accidentally copy when nothing is selected, nothing happens, which is exactly what I want. (Specifically, I don't lose the data on my clipboard!)

Comments

cheap Ray Ban Sunglasses

 on 4/24/2012 1:29 AM

Add Comment

Items on this list require content approval. Your submission will not appear in public views until approved by someone with proper rights. More information on content approval.

Title


Body *


CommentUrl


Attachments