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

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