Service Packs - SimonS Blog on SQL Server Stuff

Browse by Tags

All Tags » Service Packs (RSS)
26 July 2007 23:17

SSIS - Enhanced Error Component

For those that downloaded the enhanced error component I forgot to make it clear that the new version requires you to have service pack 1 installed. The reason being is that we are using an interface that allows us to look at the whol package in the component...
Posted by simonsabin | 1 comment(s)
Filed under: , , ,
08 May 2007 12:51

Using SMO from TSQL

If you are desperate to get your hands on the code I used in the SMO in TSQL demo I did at the usergroup meeting you can download it now from codeplex. http://www.codeplex.com/SMOinTSQL There are 2 projects in there one an SSMS project and one a C# project...
Posted by simonsabin | 1 comment(s)
Filed under: , , , , , , ,
30 March 2007 11:19

Hot fixes are always cumulative

The one thing I learnt when I was at the MVP summit a few weeks ago was that hotfixes are always cumulative, in other words you get all the other hotfixes that have been made prior to your hot fix. The reason for this is that there is one SQL Server code...
Posted by simonsabin | 1 comment(s)
Filed under: , , ,
29 March 2007 15:06

Free 2GB SQL Server USB Keys

We are holding the next UK SQL User group meeting in Central London on the 26th April from 6pm - 9pm (later if you fancy a drink) The eveneing will have a SQL event and BI event running side by side with 8 presenters and loads of giveaways including t...
Posted by simonsabin | with no comments
Filed under: , , , , , , , , , , ,
08 March 2007 07:54

Maintenance plan warning for SP2

Due to a regression bug introduced in SP2 some of the maintenance plan tasks that can operate on multiple databases may not perform as expected. If a maintenance plan component uses TSQL of this nature USE [DBFred] GO DBCC CHECKDB.... GO USE [DBSimon...
Posted by simonsabin | with no comments
Filed under: , , , , ,
06 March 2007 16:13

SP2 has changed, make sure you download the latest file

A regression bug was introduced in SP2 that resulted in a view problems when used in evironments that had other versions of SQL 2005 i.e. RTM and SP1. The SP2 download has been changed to include this hotfix. http://www.microsoft.com/technet/prodtechnol...
Posted by simonsabin | with no comments
Filed under: , ,