Home > IT Blogs > The Multifunctioning DBA/

The Multifunctioning DBA:

MS SQL

12
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...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

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...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

12