Browse by Tags

All Tags » Management Studio (RSS)

My head hurts from hitting it against a wall–SSMS log viewer

Every time I go to a client to do a review I find I’m looking in the event log trying to find information. Every time I feel like I’m hitting my head against a wall as the process is awful and painful. Given SQL is a relational database production the...

Agent XPs disabled

When you expand object explorer and see “Agent XPs Disabled” don’t worry. This happens when SQL Agent is stopped. I guess the idea is to reduce the surface area if SQL Agent isn’t running. You don’t have to manually enable them. They will be enabled automatically...

Controlling what appears on your tabs

You can control what appears on your tabs from SQL 2008 onwards. Its still not ideal, IMHO you need to have multi line tabs to show server, database, filename etc. Anyway to control what appears go to Tools | Options and then select the Tec Editor node...