I only recently discovered that SSMS will connect to different things. For instance, press the ''New query'' button. What were you connected to? The answer is the same server as your ''current'' server. But what is the current server? It is the server where you happened to have focus when the pressed the ''New query'' button. So, can you say ...

Just a quick note that we again can modify whether system messages are to go to eventlog/errorlog again. I.e., we can change the is_event_logged column in sys.messages. This is very valuable in general and specifically is you want to define Agent alerts (for which Agent polls the Eventlog). For instance: SELECT * FROM sys.messages WHERE ...

Short story: Turn on 2000 keyboard layout and then back to Standard layout. Long story:  This topic has been discussed in both the MCT (MS Certified Trainer) as well as MVP groups. Also, see http://sqlblog.com/blogs/andy_leonard/archive/2008/08/08/sql-server-2008-management-studio-function-keys.aspx, including the comments. The ...

I'm in a situation where I have configured the new data collector functionality for three instances. And there's no way to undo the config performed by the wizard! It cannot be undone by the wizard, and BOL doesn't have information on how to do this. In fact, I suspect that you in the end need to use some of the undocumented data collector ...