Kerpau!

Although, I have no idea why this happens, here is how to fix RDP/RDC connections after a SQL Server 2005 installation breaks it.

• Control Panel > Administrative Tools > Terminal Services Configuration > Connections
• Delete the RDP connection
• Right-click Connections and select Create New Connection
• Accept the wizard’s defaults
• Name it RDP-tcp or something descriptive
• Reboot, and you’re back in business!

Unfortunately, the reboot is necessary.

Here is a regular expression that works in SQL Server Management Studio. It will replace those bothersome blank lines that the query window picks up when pasting text from an HTML source.

^:b*$\n

Do a Find and Replace (or Ctrl-h)
Select Search hidden text
Select Use Regular expressions
Put ^:b*$\n in the Find what: box
Make sure Replace with: is blank
Click on the Replace All button