The Multifunctioning DBA:

MS SQL


April 29, 2009  7:27 PM

Error while installing SQL Server 2005 SP 3



Posted by: Colin Smith
Database, Database Administration, MS SQL, SQL Server

I have installed SP3 on a few SQL Servers with no issue at all. The other day I go to install it on a production instance and it fails with the following error: A Recently Applied Update, KB955706, failed to install. The update failed with that error for the following services: Database...

April 28, 2009  10:15 PM

SQL Version Script



Posted by: Colin Smith
Database, Database Administration, MS SQL, SQL Server

I needed a quick audit of some of the SQL Servers in my environment. We wanted to know what version and what SP each instance was running. I threw this together and it is pretty simple. It only checks for SQL Server 2000 SP4 and SQL Server 2005 RTM thru SP3.   Bookmark and Share     0 Comments     RSS Feed     Email a friend


April 21, 2009  7:04 PM

The Security Battle



Posted by: Colin Smith
Database Administration, DBA, MS SQL, SQL Server

I just had a battle with some applications support team members about securing our data. We have a system that connects to a SQL Server backend, this system has been in place for over a year now and is about to get a major application update. When this system was first implemented management let...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: