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):
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!)