How to Find the Data Directory of SQL Server 2005 in a Script

In versions of SQL Server prior to 2005 finding the directory where SQL Server creates its databases was pretty easy since there was a registry key named after the instance of SQL Server and a value that specified the path. With SQL Server 2005 Microsoft changed everything, making it a challenge to retrieve the correct … Continue reading How to Find the Data Directory of SQL Server 2005 in a Script

Advertisements

Dual Head on Ubuntu Hardy with Intel GM965 (Part 1)

Yesterday I got a LCD monitor that I plugged in to the docking station of my Dell D830. Using cloned mode where both the laptop display and the external monitor display the same, worked right away. But I wanted to use extended mode so that I can have a bigger workspace. Here's how I got … Continue reading Dual Head on Ubuntu Hardy with Intel GM965 (Part 1)

Security Update for SQL Server 2005 Service Pack 2 (KB948109) failed

During the last weeks Vista always claimed that there's an update to install, but it never succeeded installing it. So this afternoon I dug into it. The update in question was the Security Update for SQL Server 2005 Service Pack 2 (KB948109). It failed with error 11032. When looking at the log file in C:\Program … Continue reading Security Update for SQL Server 2005 Service Pack 2 (KB948109) failed