THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » tools » SQL Server 2008   (RSS)
  • Spooky: What do you connect to?

    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 ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on June 26, 2009
  • sp_altermessage is back in business!

    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 ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on May 14, 2009
  • Missing F8 or ctrl-N in SSMS 2008?

    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, including the comments. The ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on August 26, 2008
  • Make sure you play with data collector on a virtual machine

    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 ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on August 25, 2008
Privacy Statement